• 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…
  • Is there a link on How to use sage intelligence using the connectors ODBC Driver in EXCEL to link the data in excel ?

    Is there a link on How to use sage intelligence using the connectors ODBC Driver in EXCEL to link the data in excel ? We are trying to get information from Microsoft Excel data to be use in the integration of ODBC Driver SQL Server of Sage Accpac…
  • 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…