• 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…
  • Excel Import additional Account Segments

    Hi, We're using Sage 300 ERP 2012.1 and our chart of accounts includes accounts with one segment, three segments, or four. Currently using the excel import for journal entries, we are only able to import three segments, then if we need the fourth segment…
  • 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…