Consolidating Data in a Report

Each financial report writer allows you to combine the results from more than one business unit.

Financial Analysis consolidates business units with the same chart of accounts, and analysis code structures. You can consolidate up to 30 business units in one report.

Financial Statements consolidates an unlimited number of business units. Each can have different chart of accounts codes and analysis codes. The consolidations are defined in Financial Statement Rows (FSR). You can add the subsidiary ledger details into the same report line as the main ledger, or show them as separate lines on the report.

Financial Tables defines the consolidation requirements in Financial Table Columns (FTC). Subsidiary ledger information can be added to the main ledger details within one column, or shown as separate columns. The chart of accounts and analysis code structures can be different. The number of ledgers to be consolidated in one report is limited by the maximum of 50 column codes in any table.

Conversion Rates

In a multi-currency environment, subsidiary ledgers can be consolidated using multiple conversion rates using Financial Analysis, Financial Statements, and Financial Tables. When consolidating data from subsidiary ledgers, the currency period rates on the consolidating ledger are checked for an applicable conversion rate. If no applicable rate is found, the Currency Rate for Consolidation defined in the subsidiary Ledger Setup (LES) is used.

An applicable conversion rate on the currency period rates of the consolidating business unit means one which has the same currency code as the base currency code in Business Unit Setup of the subsidiary ledger.

If the currency period rates specify different rates for different accounting periods and account code ranges, then the data being consolidated (that is, on the subsidiary business unit) must correspond to these codes, before the conversion rate is considered applicable.