• Sage 300 2022 - What ODBC we need or must use to setup companies/system ODBC?

    Hi everyone, I have some customers with Sage 300 2022 and they have and use to setup ODBs for companies/sytem SQL Server Native Client 11.0. But with a customer we are upgrading to that same Sage 300 2022 version, and we dont found it. We download…
  • Sage 300 2022 (PU1) Workstation clients - Random Database connection errors and terrible performance

    We have Sage 2022.1 on our server which is performing perfectly (on the server or through RDP with our VPN firewall). We've installed the Sage Workstation (WSSETUP), ran the Database Setup which created the ODBC and the test connection is fine. Hours…
  • Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…