Consolidating Transactions

Use the G/L Consolidate Posted Transactions screen to reduce detail in reports by consolidating (combining) details in the accounts for which you do not need a permanent record of every transaction.

Important! When you consolidate transactions, you lose any optional field information that was posted with the transactions.

To consolidate transactions:

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.

Last published: 4/8/2016