• Sage 300 Database on Azure SQL

    Hi everyone. I'm hoping someone here can answer this, rather than having to jump into the support gauntlet. I work for an IT firm and a client of ours is presently running Sage 300 on a server VM, connecting to an MS SQL database on another VM, which…
  • 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…