• 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…
  • 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…