List of Fields in the Table
Many companies 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.
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.