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