Audience: Administrators who manage the model.
Elimination rules govern the elimination process. Use the Manage Elimination Rules page to create, edit and delete elimination rules.
Before You Begin
- Your instance must have consolidation enabled.
- Permissions Required: Model Management Access > Model and Consolidation.
- You must complete setting up eliminations before creating elimination rules.
How You Get There
From the nav menu click Modeling. From the Rules menu, select Elimination Rules.
Create an Elimination Rule
Click the New Rule button at the bottom of the screen.
Complete the fields in the Definition and Scope tabs. For detailed explanations of and information about the fields on the Definition and Scope tabs, see the following section, Elimination Rule Details.
You can click between the tabs without losing data.
You can save a partially-completed elimination rule, but it will not take effect until all required fields are completed.
If any intercompany accounts you choose for the rule have shared or master formulas, consider how the formula affects other rules and accounts. The rules that have accounts with formulas must precede the rules that have accounts depending on those formulas.
Edit, Delete, Change Order of Elimination Rules
The Manage Elimination Rules page displays the Elimination Rules list, which lists all elimination rules, along with their description, which version(s) they affect, and their start and end periods.
Navigation: Modeling > Model Management > Elimination Rules. The Manage Elimination Rules page appears.
Use the icons in the Action column to:
Edit a rule: Click the name link or click .
Delete a rule: Click .
Adjust a rule’s position in the list: Click to move the rule up or down.
Elimination Rule Details
Required. The name of the rule.
Use a clear and descriptive a name. Rule names show up in the rules list on the Manage Elimination Rules page and in the Cell Explorer.
|Description||Optional. Useful if multiple administrators are handling elimination rules. The description appears on the Manage Elimination Rules page.|
|Intercompany Debit Accounts||Select the debit accounts to use for this rule. Only debit accounts set as Intercompany will appear in this list.|
|Intercompany Credit Accounts||Select the credit accounts to use for this rule. Only credit accounts set as Intercompany will appear in this list.|
|Intercompany Difference Account||Select the intercompany difference account to use for this rule. Only system accounts set as Intercompany will appear in this list.|
|Applies to Version||
Search or browse to select the versions on which the rule applies.
Actuals: If selected and actuals sub-versions exist, the Actuals Version section appears:
|Rule Period||Choose specific months, or choose start and end of version. Revisit this setting periodically and update as needed.|
|Optional Matching Dimensions||
Optional. Specify dimensions to use when matching intercompany balances. If selected, balances with dimensions are eliminated based on the value in the dimension.
For example, suppose you select Product dimension for the eliminations rule, which has dimension values: Laptop, Desktop, Server.
The elimination process will eliminate against balances where Product is value Laptop, is value Desktop, and is value Server.
With matching dimensions, you can run eliminations reports based to see the eliminating entries sliced by dimension