Specifying Consolidation Ledgers

To specify a consolidation ledger, use the Consolidation Ledger Sets component (LEDGER_SET).

For each business unit involved in Consolidations, you can specify one ledger as the Consolidation ledger. The Consolidations process uses this ledger as the source and identifies transactions to be eliminated. Consolidation journals reference this ledger for elimination units.

In cases where business units have different base currencies in their primary ledgers, and translation ledgers are maintained for reporting on a single currency, you can use Translation ledgers as Consolidation ledgers. Consolidation does not perform any currency translation. The currency that you specify must have complete balances in place resulting from regular journal posting or from the Currency Translation process.

You specify a ledger for a business unit on the Ledger Sets page. With a common Consolidation chart of accounts, you can also consolidate at a summary level.

Page Name

Definition Name

Usage

Ledger Set Page

LEDGER_SET

Select the combination of business units and ledgers that you want to consolidate for a specific consolidation configuration.

Use the Ledger Set page (LEDGER_SET) to select the combination of business units and ledgers that you want to consolidate for a specific consolidation configuration.

Navigation:

General Ledger > Consolidate Financial Data > Consolidation > Consolidation Ledger Sets > Ledger Set

This example illustrates the fields and controls on the Consolidation - Ledger Set page. You can find definitions for the fields and controls later on this page.

 Consolidation - Ledger Set page

Automatic Populate Scroll

The Automatic Populate Scroll section enables you to select the parameters that will populate the scroll with the ledgers that you can use. After you choose parameters, click the Refresh button to populate the page.

Note: When you click the Refresh button, the system provides you with only the best guess of ledger names. Review the ledger names populated by the system, and select the ledger that you want to use in the consolidation.

Field or Control

Description

Tree

Determines the business units that will appear in the scroll. All business units in a particular tree will appear in the scroll.

As of Date

Use to select a tree if you have multiple trees with the same name.

Currency

Populates the Ledger column with the ledgers that have the same base currency defined.

Specify Ledgers to Use

When you click Refresh, the system populates the scroll area with the following:

Field or Control

Description

Business Unit

Populates the valid values in the selected tree for the specified ledger template.

Ledger

Displays a ledger associated with each business unit that has the specified currency as its base currency. You can associate a different ledger with the business unit by selecting a new one in the drop-down list box.

You can also enter business units and their associated ledgers individually by adding a row. The new business unit does not have to be part of the earlier specified tree.

Note: All business units involved in the consolidation process must have a row defined on the Ledger Set page so that the system knows which ledger to use for each business unit during the consolidation process.