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

  • Vacation Pay Rate Data

    Would anyone be able to tell me which table in the Sage 50 CA data schema contains the vacation pay rate (i.e. 4%, 6% etc.) for an employee (and the name of the column)? I am unable to locate this information through the data dictionary. Thank you.

  • ODBC connection failing

    I am trying to connect to the Sage 50 database using ODBC/My SQL connection.  In MySQL Connector/ODBC, I enter Sage username and password, , I select TCP/IP Server : localhost (database is local on this computer), I leave the port to default (13540), and…

  • RE: Lookup the default invoice number

    Hi Nick_Alpha,

    Yes, the next invoice number is stored in tCompShr.lInvNum

    lInvNum Number FT_LONG 4 Next invoice number

    lNxtPONum Number FT_LONG 4 Next purchase order number

    lNxtSONum Number FT_LONG 4 Next sales order number

    lNxtRcNum Number FT_LONG 4…