Consolidation Exception Report: Unmapped Subsidiary Accounts

Review any subsidiary accounts (included in the account range you specified for your consolidation transfer) with non-zero balances that were not consolidated into your parent ledger because the accounts were not mapped. This report generates data only for consolidations with a method of Balances. It does not report on consolidations with a method of Transactions.

Use this report to determine if your consolidation is complete prior to posting. To request this report, you must use the audit mode run option when transferring your subsidiary data.

General Ledger prints a line for each subsidiary account in the account range that was not consolidated into your parent ledger, and its corresponding account balance.

Note: This report produces output only for actual amounts. This report does not produce output for budget consolidations.

Note: You can only submit this report from the subsidiary ledger's responsibility.

Parameters

When you request this report, General Ledger prompts you to enter the following:

Consolidation Definition: Enter the name of a consolidation definition you have defined and have transferred in audit mode.

Note: Your data access set must provide read access to the subsidiary ledger and your definition access set must provide the Use privilege to the consolidation definition to use this report.

Subsidiary Period: Choose the period in your subsidiary ledger that was consolidated into your parent ledger.

Amount Type: Choose the amount type (Period-to-Date, Quarter-to-Date, Year-to-Date, or Project-to-Date) used for consolidating to your parent ledger. For average balance ledgers, you can choose additional amount types (End of Day, Period-Average-to-Date, Quarter-Average-to-Date, and Year-Average-to-Date).

Selected Headings

Refer to the selected heading descriptions below for additional information.

Subsidiary Account: a line for each subsidiary account in the account range that was not consolidated into your parent ledger.

Description: description of the subsidiary natural account segment value.

Account Balance: balance for each subsidiary account in the account range that was not consolidated into your parent ledger. Each line amount refers to a Period-to-Date, Quarter-to-Date, Year-to-Date, Project-to-Date, End of Day, Period-Average-to-Date, Quarter-Average-to-Date, and Year-Average-to-Date account balance relative to the subsidiary accounting period used for consolidation.

Related Topics