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

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

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

  • dbClient.GetConnectionInfo(szFileDir, szHost, szPort) parameters

    I'm writing an application in VB.NET to run custom queries against the Sage 50 database. I've gone through the SDK manuals, but have some additional questions while walking through the sample code. We run the connection manager on the server and install…