Specifying Summary Ledger Consolidations

To set up consolidation on summary ledgers:

  1. Specify the summary ledger template.

    For all the summary ledgers that are used for consolidation, you must specify the consolidation log and consolidation equity temporary records for summary ledger templates on the Ledger Template − Record Definitions page. If you plan to use the Affiliate field to identify intercompany transaction balances in summary ledger, your summary ledger must retain the affiliate values.

  2. Define elimination sets on the summary ledger.

    To consolidate on the summary ledger, use the Elimination Sets page to define elimination sets based on a summary ledger. You must specify both a ledger template and the name of the summary ledger so that the system knows how to prompt for ChartField and ChartField values.

    If the affiliate value is kept in the summary ledger table, and you want to use the Affiliate method of elimination, check the Match Affiliate Value option on the Elimination Lines page. If the Affiliate field is not one of the fields in the summary ledger template, you must specify the business unit value in the elimination set.

  3. Define minority interest sets on the summary ledger.

    Specify the appropriate ledger template and ledger for the summary ledger on the Minor Int Source (minority interest source) page.

    On the Minor Int Target (minority interest target) page, ensure that the Subsidiary Equity and Parent Investment values are ChartField value sets based on the same summary ledger.

  4. Define consolidation ledger set.

    Use the Consolidation Ledger Set page to specify the summary ledger names to be used for each business unit for consolidation.

  5. Define consolidation sets on the summary ledger.

    Use the Journal Options page to specify the appropriate ledger template and ledger for the summary ledger. The ledger set used for consolidation processing should be based on the same summary ledger.

  6. On the Set Options page, ensure that elimination sets are based on the same summary ledger.

Related Topics