Creating Consolidation Ledgers

You can use consolidation ledgers to roll up transactions from functional ledgers or from other consolidation ledgers for reporting.

To create and set up a consolidation ledger:

1. In Ledger Maintenance, click the New button in the ribbon.

2. Select the Consolidation radio button for the Ledger Type radio button.

3. Select other options for the ledger, just as you would for a functional ledger.

4. If you want the ledger to share a chart of accounts with another ledger, select the Share Chart of Accounts check box and enter the ledger in the Accounts Ledger ID field.

5. Click the User Security tab, and double-click the users who can access the ledger.

6. Click the OK button in the ribbon.

7. If the ledger does not share the chart of accounts of another ledger, set up the accounts for the ledger in Account Maintenance or General Ledger Account Import.

8. In Ledger Maintenance, select the consolidation ledger, and click the Update button in the ribbon.

9. Click the Consolidation Ledgers tab, and for each ledger that is related to the consolidation ledger, perform the following:

   1. Enter the related ledger in the Source Ledger ID field.

   2. If you only want to relate accounts for specific companies, clear the All Companies check box, and specify the company or companies.

   3. Enter the consolidation ledger in the Destination Ledger ID field.

   4. Select whether transactions are translated in real time or manually.

   5. Enter the currency in the consolidation ledger that is the currency for transactions in the source ledger in the Source Currency field.

   6. Click the Add button.

10. Click the Period Cross References tab, and set up period cross references for each source ledger, as follows:

    1. Enter a source ledger ID in the Source Ledger ID field.

    2. Enter the source years and periods that are equivalent to the destination ledger years and periods. If you enter a period year in the first row, you can use the Fill Periods button in the ribbon to automatically enter the other periods and years.

11. Click the Account Cross References tab, and set up account cross references for each source ledger, as follows:

    1. Enter a source ledger ID in the Source Ledger ID field.

    2. Select criteria for the accounts in the source ledger you want to display.

    3. Click the Show Data button in the ribbon. The accounts and consolidation groups that meet the selected criteria display.

    4. Enter the consolidation ledger accounts in the Destination Account column for accounts that are equivalent to source ledger accounts or consolidation groups.

12. Click the OK button in the ribbon. The Confirm Update dialog box appears and asks if you want to replace the existing ledger.

13. Click the Yes button.

Note If you want to create journal entries in the consolidation ledger for previously posted journal entries in a source ledger, use Consolidation Journal Rebuild to create journal transactions for the journal entries, and then use Consolidation Journal Management to create the destination ledger journal entries.