Setting up Company consolidation | DC1 Help Centre 12.0

Home
/
Setup Guides
/
Financials
/
Company consolidation
/
Setting up Company consolidation

This is the order in which the setup needs to be defined and the actions should be taken to run the company consolidation routine.

Originating company tasks

(Prerequisite: You must be working in the applicable company to perform the tasks.)

File/Table	To do
Work with chart of accounts	Define a consolidation type which indicates the exchange rate to be used in this routine. You do this on main account level in the originating company, the Consolidation type field. Note: A consolidation type must be defined for all accounts which are to be transferred. Otherwise, balances and budget values will not be retrieved.
Work with consolidation company hierarchy	Define which company is to be the corporate company for the originating company you are working in. Define the base account hierarchy to be used during company consolidation (in the Company hierarchy maintenance). You define the relationship between the account structure in the corporate company, and the account or summary id structure in the originating company. You define which account parts, summary id parts, or fixed account numbers you want to transfer to the corporate company. Decide if you want to transfer system currency and/or quantity balance types from the originating company to the corporate company for both actual balances and/or budget values for a main account. Note: System currency in the originating company will become transaction currency in the corporate company. If applicable, convert the accounting periods of the originating company to the accounting periods of the corporate company. Note: Both companies must use the same fiscal year. Decide which budgets in DC1 Financials you want to transfer from the originating company to the corporate company.
Work with account/sum id part conversions	Define exceptions to the setup in the Work with consolidation company hierarchy routine by establishing how accounts or summary id parts in the originating company should be converted/transferred to accounts in the corporate company. Decide if you want to transfer system currency and/or quantity balance types from the originating company to the corporate company for both actual balances and/or budget values for a main account. Note: System currency in the originating company will become transaction currency in the corporate company.
Work with G/L translation periods	Change the original period for transactions that are to be translated according to a historic rate (consolidation type 3 in the Account file).
Create interface file	Run this program to validate the relationship between the originating companies and the corporate company to see if a consolidation can be done without any errors. The validation is performed according to the setups in the Work with consolidation company hierarchy and the Work with account/sum id part conversions routines. Only one accounting year can be created at a time.

Corporate company tasks

(Prerequisite: You must be working in the applicable company to perform the tasks.)

File/Table	To do
Work with consolidation transfer controls	Enter a type from Work with interface types that the system should use when transferring consolidation transactions for a selected originating company. Note: The interface type must be unique for each originating company for the following reasons: If the same interface type is used for more than one originating company, all transferred values will end up in the same journal with the same voucher type and voucher number, if they are transferred at the same time. It is, therefore, recommended that you always use a unique interface type for each originating company. This is valuable in case you need to run a new total update for the originating company. You must then be able to eliminate previously updated postings for the same period in a specific originating company.
Update corporate company	Run this routine to perform the actual update of the originating company data into the corporate company. The balances from the originating company interface files will be retrieved to the G/L transactions interface file in the corporate company, and the corporate company will be updated.
Work with pseudo accounts	The following pseudo accounts must be defined: XCOER – Consolidation transfer balance differences. This pseudo account is used if transferred values in local currency for one originating company are out of balance. The originating company code can be used as suffix. XCOXD – Consolidation currency translation differences. This pseudo account is used for net gain/loss after currency translation. The originating company code can be used as suffix.
Retrieve financial transactions	You have to run this routine separately if you have the Automatic update field on the Update corporate company panel set to NO.

Related topics