Consolidating Transactions
You can consolidate transactions only if you use the Balance Type of Actual for the consolidation. If you have average balance processing enabled, you should consolidate into a non-consolidation set of books with average balances enabled.
To consolidate transactions:
1. Navigate to the Consolidation Workbench window.
2. Select the consolidation mapping you want to transfer. The mapping must use the transactions consolidation method.
3. Choose the Transfer button from the State Controller.
The Transfer Consolidation Data window will appear, displaying the Method, Currency and Set of Books information defined for this mapping.
Note: General Ledger automatically enters Actual for the Balance Type, Standard for the Usage type and PTD for the Amount Type.
4. Enter the subsidiary's accounting Period from which you want to consolidate.
5. Enter the Standard Period to which you want to consolidate in your parent set of books. You can consolidate to any period that is open or future enterable.
6. Select your consolidation Run Options.
7. Choose the Select Batches button to specify which journal batches you want to consolidate.
8. Choose a Batch Query Option:
Unconsolidated: to query those batches in your subsidiary set of books that have not been previously consolidated.
Consolidated: to query batches that have been previously consolidated.
All: to query both previously consolidated and unconsolidated batches.
9. Choose Transfer to launch a concurrent process to transfer your subsidiary data to your parent.
10. If you did not choose the Run Journal Import option for your transfer, use the Import Journals window after the transfer completes to create the consolidation journal batch in your parent set of books.
See Also
Consolidating Balances
Consolidation Run Options
Global Consolidation System
Consolidation Workbench
Mapping Subsidiaries to Your Parent
Preparing Subsidiary Data
Transferring Consolidation Sets
Posting Subsidiary Data
Creating Eliminating Entries
Notes on Consolidating Average Balances
Overview of Average Balance Processing