• 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 2012 (v6.2) with SQL Client Native 11?

    Hi, We are installing a Sage client in a new machine as user change its PC but when trying to set up ODBCs we dont found Native 10 that is installed in old machines. Just Native 11. Any problem? Not at all? Thank you
  • 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…
  • Current fiscal period for a company in database?

    Can someone please tell me what table/column will give me the current fiscal period for a company?