Use segment rules, account rules, or a combination of both to specify how to transfer balances or transactions from your source chart of accounts to your target chart of accounts.
Notes: You must define a segment rule action for each segment in your target's chart of accounts. You cannot define more than one action per segment.
Segment rules: Map the source account segments to the target account segments. For example, you can map the Department segment of your source chart of accounts to the Cost Center segment of your target chart of accounts.
Account rules: Map a specific source account or a range of accounts to a specific account in your target chart of accounts. For example, you can map source account 02.300.5400.100 to the account 01.100.3000.000.000 in your target chart of accounts. Or, you might map the entire range of the source accounts 02.300.5400.100 through 02.300.6999.100 to account 01.100.3000.000.000 in your target chart of accounts.
Segment rules are preferable to account rules because:
You can quickly create a chart of accounts mapping by using segment rules. For example, if your target account has only three segments, you can map the entire chart of accounts from the source with just three segment rules.
If using the chart of accounts mapping for consolidations, consolidations based on segment rules process faster.
Note: Use account rules only for specific exceptions where a source 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
Navigate to the Chart of Accounts Mapping window.
Enter or query a chart of accounts mapping.
Choose the Segment Rules button.
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: This action produces the same result as the Copy Value segment rule in earlier versions of General Ledger. General Ledger also prevents you from copying larger source segments to smaller target segments. For example, you cannot copy the subsidiary value 101 to a target 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 target chart of accounts will use.
Suggestion: Use this action when your target account has more segments than your source account.
Note: This action produces the same result as the Single Value segment rule in earlier versions of General Ledger.
Use Rollup Rules From: Map values from your source segments to your target segments using the rule specified in the Rollup Rules region.
If you chose the Use Rollup Rules From action in the previous step, enter the mapping rules in the Rollup Rules region.
Save your work.
Additional Information: 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 and then create a new one.
Navigate to the Chart of Accounts Mapping window.
Enter or query a chart of accounts mapping.
Choose the Account Rules button.
Enter the source accounts that you want to consolidate. If you enter multiple ranges, they must not overlap.
Enter the target account to which you want to map each source account range.
Save your work.
Other Sources
Secondary Ledgers
Primary to Secondary Ledger Mapping