• 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…
  • Office 365 and sending e-mails from Sage 300 AR

    Client just upgraded to Sage 300 version 2016 and Office 365. They send invoices from AR (they don't have PrintBoss) and are getting the annoying message "a program is trying to send a message on their behalf...." where they have to click Allow for each…