Specifies the companies that are part of a group. If this is the case, you need to be able to consolidate the various companies' financial statements into a single consolidated financial statement.
To have the program carry out a consolidation, you set up a consolidated company. In this consolidated company, the total amounts for all accounts in the group, from both the parent company and subsidiaries, are added together.
You can have the program import account totals from the various business units, add them up and put the results in the chart of accounts of the consolidated company. In the G/L accounts of the various business units, you must indicate the G/L accounts in the consolidated company to which the total should be transferred. Then the program will be able to import this financial information correctly.
If you want dimension codes and their dimension value codes to be carried over from the business units to corresponding codes in the consolidated company, you should define the codes for the consolidated company in both the Dimension and Dimension Value tables. If you choose not to set up consolidation codes for dimensions and dimension values in the business unit, the dimensions and dimension values in the consolidated company must be identical.
You must set up the parent company, subsidiaries, and affiliates in this window.
Important
Complete the Business Units window only for the consolidated company itself, that is, the one to which the various business units will be imported.
To import totals from the various business units, you run the Import Consolidation from DB and Import Consolidation from File batch jobs.
List of Fields in the Table
The following table lists the fields in this table.
| Exch. Rate Gains Acc. Field, Business Unit Table |
General Ledger |
| Consolidation % Field, Business Unit Table |
General Ledger |
| Residual Account Field, Business Unit Table |
General Ledger |
| G/L Account No. Field, Business Unit Table |
Spain Local Functionality |
| Code Field, Business Unit Table |
General Ledger |
| Balance Currency Factor Field, Business Unit Table |
General Ledger |
| Company Name Field, Business Unit Table |
General Ledger |
| Income Currency Factor Field, Business Unit Table |
General Ledger |
| Minority Exch. Rate Losses Acc Field, Business Unit Table |
General Ledger |
| File Format Field, Business Unit Table |
General Ledger |
| Data Source Field, Business Unit Table |
General Ledger |
| Consolidate Field, Business Unit Table |
General Ledger |
| Currency Exchange Rate Table Field, Business Unit Table |
General Ledger |
| Exch. Rate Losses Acc. Field, Business Unit Table |
General Ledger |
| Last Balance Currency Factor Field, Business Unit Table |
General Ledger |
| Minority Exch. Rate Gains Acc. Field, Business Unit Table |
General Ledger |
| Equity Exch. Rate Losses Acc. Field, Business Unit Table |
General Ledger |
| Ending Date Field, Business Unit Table |
General Ledger |
| Equity Exch. Rate Gains Acc. Field, Business Unit Table |
General Ledger |
| Starting Date Field, Business Unit Table |
General Ledger |
| Name Field, Business Unit Table |
General Ledger |
| Comp. Exch. Rate Losses Acc. Field, Business Unit Table |
General Ledger |
| Currency Code Field, Business Unit Table |
General Ledger |
| Comp. Exch. Rate Gains Acc. Field, Business Unit Table |
General Ledger |
| Equity Exch. Rate Losses Acc. Field, Business Unit Table |
General Ledger |
| Exch. Rate Gains Acc. Field, Business Unit Table |
General Ledger |
| Consolidation % Field, Business Unit Table |
General Ledger |
| Residual Account Field, Business Unit Table |
General Ledger |
| Code Field, Business Unit Table |
General Ledger |
| Ending Date Field, Business Unit Table |
General Ledger |
| Equity Exch. Rate Gains Acc. Field, Business Unit Table |
General Ledger |
| Balance Currency Factor Field, Business Unit Table |
General Ledger |
| Company Name Field, Business Unit Table |
General Ledger |
| Starting Date Field, Business Unit Table |
General Ledger |
| Income Currency Factor Field, Business Unit Table |
General Ledger |
| Minority Exch. Rate Losses Acc Field, Business Unit Table |
General Ledger |
| Name Field, Business Unit Table |
General Ledger |
| File Format Field, Business Unit Table |
General Ledger |
| Comp. Exch. Rate Losses Acc. Field, Business Unit Table |
General Ledger |
| Data Source Field, Business Unit Table |
General Ledger |
| Consolidate Field, Business Unit Table |
General Ledger |
| Currency Exchange Rate Table Field, Business Unit Table |
General Ledger |
| Exch. Rate Losses Acc. Field, Business Unit Table |
General Ledger |
| Currency Code Field, Business Unit Table |
General Ledger |
| Last Balance Currency Factor Field, Business Unit Table |
General Ledger |
| Comp. Exch. Rate Gains Acc. Field, Business Unit Table |
General Ledger |
| Minority Exch. Rate Gains Acc. Field, Business Unit Table |
General Ledger |
| G/L Account No. Field, Business Unit Table |
Spain Local Functionality |
See Also
Reference
Dimension
Dimension Value
Business Unit Card
Business Unit List
Other Resources
Import Consolidation from DB
Import Consolidation from File