Using Summary Accounts (Role up rule)
You can choose to consolidate balances from your subsidiaries’ summary accounts when you do not want to consolidate detail accounts. A summary consolidation will generally run faster than a detail consolidation because there is less data to transfer. Note: You can only consolidate summary accounts if you are using the balances consolidation method.
When you transfer your subsidiary data for a summary consolidation, General Ledger checks for overlapping accounts. If overlapping accounts are defined solely within your segment rules, the consolidation transfer will fail and the system generates an exception report showing which accounts overlapped. If accounts defined by your segment rules overlap with accounts defined by your account rules, the account rules override the segment rules. General Ledger corrects any double–counted balances that result from the overlapped accounts. If your subsidiary account has more segments than your parent, the additional subsidiary segments are left unmapped. During a summary consolidation, the unmapped segment is treated as a summary account segment with a value of ”T”.
To map subsidiary summary accounts

1. Specify segment rules for your consolidation mapping.
2. For your account segments, select the Use Rollup Rules From action.
3. For your rollup rules, use either the Summary/Parent or Summary/Parent Ranges rule.
4. Select your summary accounts. For the Summary/Parent rollup rule, enter the summary account in the Subsidiary Segment Parent Value field. For the Summary/Parent Ranges rollup rule, enter a range of summary accounts in the Low and High fields of the Subsidiary Segment Ranges region.
Suggestion: Map summary accounts first before mapping the
entire chart of accounts.
Comments
Post new comment