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

  • ODBC issue (works from Excel when sysadmin has no password but not when sysadmin has a password

    Trying to connect to the Sage 50 Canadian (non cloud) database using excel through ODBC

    MySql connector allow me to select the Sage50:COMPANYNAME.SAI file and the population of the correct path to the server and port 

    Initial attempts with the sysadmin…

  • Direct DB Connections via Connection Manager | Changing Port #s

    Hi folks,

    I have a client that uses Sage 50 (2018.1 + Connection Manager v7.0).  They host Sage on a MS Azure server.  They have 6 Companies (DBs) that I'd like to be able to connect to so that I can pull some high-level data into a custom reporting tool…

  • ODBC Connection Access Denied (Password error)

    Since we installed the latest upgrade for Sage 50 to Version 2018.0, we are unable to connect to the simply database with our third party software using a ODBC Connection.

    Over the past 10 years I have always managed to make the appropriate adjustments…

  • table tSalOrdr ...does it have a flag for the latest copy of the order?

    Is there a flag in the table tSalOrdr which indicates the last saved copy of a sales order. I am using SQL to query a sales order and I am finding duplicates which are related to every instance a sales order was saved. But the high Sales Order unique…

  • RE: Query for job costing across three databases

    Well, this has proven to be a bit of a wild goose chase so far!

    I've had a few offline discussions with Richard Ridings as well, and I now have a query that works fine (thanks Richard!) - as long as it is run manually. I can run all three - manually …