• How to decrypt AccountNumber1 - AccountNumber4 in JRNLHDR

    When I query JRNLHDR for payroll entries, AccountNumber1 - AccountNumber4 look like Base64-encoded values. I tried straight Base64 decoding but that returned gibberish characters. I'm guessing they are encrypted then encoded. Are we supposed to be able…
  • Is it possible to get the current accounting period from the ODBC interface?

    The COM API has a GetAccountingPeriods function. Is that information available via the ODBC interface?
  • Updating Comments field in JrnHdr table - Sage50

    Hi, Understanding the standard ODBC connection does not allow Write permissions, however i would like to know if there is a possibility of setting/creating a user which would have the permissions to write to the JrnHdr table, specifically the Comments…
  • TimeStamp field format in Audit Trail table

    What is the TimeStamp field format when using MS Access to link to the AUDITTR.DAT (Audit Trail) table? I can’t determine how to convert the TimeStamp field to a usable date/time format. When running the canned Sage report, it shows the date/time correctly…
  • SDK and Updating Employees

    FormerMember
    FormerMember
    When we hire new employees where I work, we have to create accounts in all kinds of different programs. Plus create windows accounts and email accounts. I wrote a Information Management Program that I have connectors to all our programs (all Microsoft…
  • Getting PeachTree API exception - Entity is read-only

    FormerMember
    FormerMember
    The company account is accessible through the desktop Sage 50 US Edition just fine. When we try to access through our app that uses Sage API to access it gives the following message. ANyone knows what the issue is? WIndows 2012 Server R2 Sage 50…
  • Sage sdk singleton error

    FormerMember
    FormerMember
    Hi, We use the sage sdk framework for a tool who works well, but for 90% of installation case, we have a "Sage.sdk.singleton" during the connection process. In local, we can bug fix this by reinstall Sage. but for our clients, that's more complicated…
  • Pervasive DSN: Determine which company goes with which database?

    I have multiple copies of our company loaded on a standalone PC, basically a separate company for every two years (so 2012+2013, and then another company for 2014+2015, etc). I have renamed each company appropriately internally within PT (such as ABC…
  • Factory Lists are empty

    I am following the documentation provided with the SDK download. I have been able to successfully begin a session but all of the factory lists are empty. For example when i am in the Sage 50 accounting interface there are many vendors listed but when…
  • Getting A Vault GUID

    FormerMember
    FormerMember
    We are using Sage50 with Sage Exchange for CC Processing. I assume Sage Exchange uses the Vault to store the CC#'s offsite. As such I assume that the Vault GUID is stored back into Sage50 somewhere. Where would that be and can I get access to it? (I suspect…
  • Sage 50 Accounting database table layout?

    I've asked a similar question earlier regarding the database layout/design and got a piece of code from someone (which I will paste below). This piece of code gets the Shipping info, the order number, and other info. What I'm looking for is how to get…
  • Get/Read Ship-To Address from Sage 50 Accouting for a specific Sales order

    Is there a way (and I imagine there is) to read the Ship-To name and address information for a particular sales order from the peachtree database to an external application using the Sage 50 SDK? I will basically be using an ODBC connection to the Peachtree…