To consolidate multiple ledgers that have different primary currencies, accounting calendars, or charts of accounts, you must first map your subsidiaries' charts of accounts to your parents' chart of accounts.

A chart of accounts mapping is a set of instructions for mapping accounts or entire account segments from a subsidiary chart of accounts to the parent chart of accounts. The chart of accounts mapping can then be assigned to a consolidation definition that is used to transfer consolidation data from your subsidiary ledger to your parent ledger.

To define a chart of accounts mapping, see Consolidating Ledgers with Different Charts of Accounts.

Notes:

• You must define a segment rule action for each segment in your parent's chart of accounts. You cannot define more than one action per parent segment.

• Segment rules are preferable to account rules because:

  • It's fast and easy to create a consolidation by using segment rules. For example, if your parent account has only three segments, you can map a subsidiary's entire chart of accounts with just three segment rules.

  • Consolidations based on segment rules process faster.

    Suggestion: Use account rules only for specific exceptions where a subsidiary account cannot be mapped correctly with a segment rule.

• Account rules override segment rules if there is any conflict.

• If you define segment rules for dependent segments in your chart of accounts, the list of values for the dependent segment value may appear to contain duplicate entries (if you have defined the same dependent value and description for different independent segment values). Choose any entry with the appropriate value; the Global Consolidation System does not use the description.

To enter segment rules:

1. Navigate to the Consolidation Definition window and choose the Mapping button.

2. Enter or query a chart of accounts mapping.

3. Choose the Segment Rules button.

4. For each source segment being mapped, enter the Target segment name to which it will map, an Action, and the Source segment name. You can use only one action for each target segment. Possible Actions include:

   Copy Value From: Copy all values in your source segment to the same values in your target segment. The segments do not have to use the same value set, but must use the same segment values.

   Note: General Ledger prevents you from copying larger subsidiary segments to smaller parent segments. For example, you cannot copy the subsidiary value 101 to a parent value set with a maximum length of 2.

   Assign Single Value: Assign one specific value that will be used for the target segment. You must enter the value that the parent chart of accounts will use.

   Suggestion: Use this action when your parent account has more segments than your subsidiary account.

   Use Rollup Rules From: Map values from your source segments to your target segments using the rule specified in the Rollup Rules region.

5. If you chose the Use Rollup Rules From action in the previous step, enter the mapping rules in the Rollup Rules region.

6. Save your work.

   Note: Once you save your work, you cannot modify your rollup rules, except to change the target and source segment detail values. To change a rollup rule, delete it then create a new one.

To enter account rules:

1. Navigate to the Consolidation Definition window and choose the Mapping button.

2. Enter or query a chart of accounts mapping.

3. Choose the Account Rules button.

4. Enter the Source Accounts that you want to consolidate. If you enter multiple ranges, they must not overlap.

5. Enter the Target Account to which you want to map each subsidiary account range.

6. Save your work.