Share via

Business Unit Table

  • Article

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

To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.

Field Location
G/L Account No. Field, Business Unit Table Spain Local Functionality
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
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
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
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
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

See Also

Reference

Dimension
Dimension Value
Business Unit Card
Business Unit List

Other Resources

Import Consolidation from DB
Import Consolidation from File