Configure consolidation in a subsidiary

1. Go to the Chart of accounts (GL202500) window.
2. For each account, in the Consolidation account column, specify the parent company account to consolidate the data.

   You may select from the list of the subsidiary accounts if the parent company chart of accounts is similar to the subsidiary chart. Multiple accounts may be mapped to the same account on the parent chart.

3. Click .

1. Click the icon.
2. In the Filter settings dialog box, select Consolidation account as the property and Is zero as the condition.
   
   If you want to save the filter for future use, click Save and enter a filter name before you close the Filter settings dialog box .
3. Click OK to close the dialog box and apply the filter.
   
4. The system will display the list of general ledger accounts that were not mapped.
5. Map these accounts, if any, and save the changes.

You can provide mapping for any subaccount structure in the parent or subsidiary.
For simplicity, we have based the following procedure on these assumptions:

• Subaccounts in subsidiaries and in the parent company have the same general structure, with one additional segment in the parent subaccounts used to designate the subsidiary.
• The subsidiaries do not have such a segment.
• All other segments in the subsidiaries have values that can be easily mapped to the appropriate segment values in the parent company.

You map subaccount segments to segments in the parent subaccounts by using the Segment keys (CS202000) window as follows:

Go to the Segment keys (CS202000) window.

1. In the Segment key ID field, select SUBACCOUNT.
2. For each of the segments, in the Consol. order column, type an integer to specify the order of this segment in the parent subaccount.
3. In the Number of characters column, specify the lengths of appropriate segments in the parent company.
4. Click .

You map segment values to parent subaccount segment values in the Segment values (CS203000) window as follows:

1. Go to the Segment keys (CS202000) window.
2. In the Segmented key ID field, select SUBACCOUNT. For each of the segments, perform the following steps:
   • In the Segment ID field, select the segment by its number in the subsidiary subaccount.
   • In the table area, for each of the segment values, specify the matching value in the parent subaccount segment in the Mapped value column.
3. Click .

1. Go to the Ledgers (GL201500) window.
2. Review the list of ledgers available in your system and select the Is consolidation source check box for the appropriate ledger.
3. Use the following guidelines in selecting the ledger:
   • If consolidation will be performed in a base currency other than the base currency of the subsidiary, select the reporting ledger that will contain the translated trial balance or budget data.
   • If consolidation will be performed in the subsidiary base currency, select the actual ledger.
   • If consolidation will be performed for only budget data in the subsidiary base currency, select the budget ledger.