How to Consolidate Transactions in Sage 300 General Ledger


  1.  Open General Ledger > G/L Periodic Processing > Consolidate Posted Transactions.
  2. In the Consolidate for field, specify how to select accounts for consolidation.  You can by account number or by segment.
  3. In the From and To fields, specify the range of account numbers or segments for which to consolidate posted transactions.
  4. In the Through Period Ending field, specify the last fiscal year and period through which to consolidate transactions.
  5. Use the Consolidate By fields to specify whether to consolidate by:
    • Account and fiscal period, where all transactions for the same account and fiscal period are consolidated into one transaction. If you are consolidating by account and fiscal period, enter the source code to assign to consolidated transactions.
    • Account, fiscal period and source code, where transactions are consolidated only if they have the same source code.
    • Account, fiscal period, and source ledger, where transactions are consolidated if they share the same source ledger. If you are consolidating by account, fiscal period, and source ledger, select the ledgers whose transactions you are consolidating, as well as
      the source code to assign to consolidated transactions from the source ledger.
      • If you use a multicurrency ledger, amounts are also consolidated by source currency.
  6. Click Process.