Browse By Tags

  • Sage 2019.2 - Get Open Invoices using Query?

    Hello would like to know if it's possible to get a list of all open invoices using  SDKDatabaseUtility RunSelectQuery command?

    I've looked around here and also the DataDict but can't really find what tables I need to link to get this data.  Any…

  • SDK and Updating Employees

    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

    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 US…

  • SDKInstanceManager OpenDatabase always returns false and has no error messages

    Hi, 

    I'm trying to work through the C# sample project in the Sage 50 Accounting SDK (Simply) but for some reason I can't get the opendatabase connection to let me access the database. I have set up my user in the Sage app and I know my username and password…

  • Sample ODBC/SQL queries for getting Sales Order information, Customer Information, and inventory information?

    Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…

  • Where payment terms are stored for the customer in Sage 50 CA Edition?


    I'm working on extracting data from the database sage 50 CA, but in the documentation containing the data definition , I have not found the relationship of the payment terms with customers, or where it is stored ( table).

    Here is the information that…
  • How to capture the data returned wSDBSelectRecords in sage 50 2016 CA SDK with Visual Basic .NET?

    I´m using ConnectionManagerService.dll and I am using the function wSDBSelectRecords with this syntax: 

    Call wSDBSelectRecords(iDBLink, iTBLink, "", 0, True)

    But I do not know how to capture the data you are going to select in a DataTable…