• 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…
  • find deleted entries

    Hi, Is there a way to find deleted entries in GL and the amount. These entries came from AR and AP and they've been posted in Subledger. And I'd like to know if we can find out the User who deleted these entries.
  • Looking Import specifications for a new MRP software.

    We currently use Sage 300 ERP for financials. Our MRP (Seradex OrderStream) will export daily AR/AP information and we import it into Sage via the appropriate forms Import. Our China facility is also using Sage 300 ERP for financials but they currently…