• 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…
  • Batch email processing gives random results

    We are trying to perform a batch print from a processed file. There are 21 customers in the file and each requires that an email be sent, when we try and run through the process it seems to randomly email only a portion of the customers. Last time it…