Consolidating Data in a Financial Statement

Financial Statements can consolidate data from an unlimited number of business units. These business units can use different chart of account codes and analysis codes.

The consolidations are defined in Financial Statement Rows. In addition to identifying the account, or range of accounts, and selection criteria for the row you identify the business unit for the row, as the Subsidiary Ledger. The transactions are extracted from this ledger, for the accounts and selection criteria referenced on the row. If you leave the Subsidiary Ledger field blank, the system uses the current business unit.

By using the Subsidiary Ledger field, you can show one row on the report for the current ledger, and another for each of several subsidiary ledgers. If you want to summarize these rows into one row, you would have a Line type row with a blank subsidiary ledger code for the current ledger, followed by Continuation rows for each subsidiary ledger.

If the subsidiary ledgers are maintained in a different base, or second base/reporting currency, you can use the revaluation facility to convert the values to the required currency. See Multi-Currency Financial Reporting.