• How knowing your version can help save time setting up your database

    Did you know that Sage 50--U.S Edition version 2020 and later use Actian Zen for the database engine, while versions 2019 and earlier use Pervasive? Head over to our article on how to troubleshoot the installation of your database to find out more!
  • Sage 2023 - Serious flaw in current release. Need fix right away.

    Based on the multiple experiences I'm reading here about 2023, it is clear that there is a flaw with this release. After working with support for almost 10 hours, we've come to the conclusion that it is not our network or environment. The database itself…
  • 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…