Set up elimination rules for transactions
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
Although elimination rules can be created in any legal entity, to use elimination rules, you must set them up in a consolidation legal entity. A warning will be displayed if you open the Ledger elimination rule form, and the Use for financial elimination process option in the Legal entities form is not selected.
Note
We recommend that you use Management Reporter for Microsoft Dynamics ERP to combine the financial results for multiple legal entities in a consolidated format. Management Reporter lets you create consolidated financial reports across legal entities, use Microsoft Excel to import consolidation data from other sources, and translate amounts into any number of reporting currencies without having to run the consolidation process in Microsoft Dynamics AX.
For more information about how to consolidate transactions by using Management Reporter, see Financial consolidations and currency translation.
Elimination rules are stored on a per-legal entity basis and must be unique in the legal entity that they are saved for.
You must specify an existing elimination legal entity in which the elimination journal will be created. The list will include all legal entities that you have access to. You can enter an elimination journal name that has a journal type of Elimination for processing.
Create an elimination rule
Click General ledger > Setup > Posting > Ledger elimination rule.
Click New to create a rule.
Enter an identifier and a description for the elimination rule.
In the Destination company field, select the legal entity where the elimination journal will be created.
Enter or select the effective and expiration dates for the elimination rule.
Select the Active check box to activate the elimination rule.
In the Name field, select a journal name.
Click Lines to create elimination rule lines.
Create elimination rule lines
Click General ledger > Setup > Posting > Ledger elimination rule. Click Lines.
Click New to create a line.
Select the elimination method.
If you select Net change, go to step 4.
If you select Fixed amount, go to step 5.
If the elimination method is Net change, enter or select information in the following fields.
Field or button
Description
Source account
Select the account to retrieve the amount from.
Account specification
Select which account the transaction will be posted to for the destination legal entity.
Destination account
If you selected User specified in the Account specification field, select a destination account that will be used instead of the source account.
If you selected Source in the Account specification field, the respective account that is defined in the source will be used during the allocation process.
Dimension specification
Select the dimension for the destination legal entity that the transaction will be posted to.
Source dimensions button
Select the dimensions to retrieve the amount from.
Destination dimensions button
If you selected User specified in the Dimension specification field, select the dimensions to associate to the elimination rule.
If you selected Source in the Dimension specification field, the dimensions that are defined in the source will be used during the elimination process.
If the elimination method is Fixed amount, enter or select information in the following fields.
Field or button
Description
Destination account
Select the account that the transaction will be posted to.
Fixed amount
Enter the debit amount for the destination account or dimension.
Destination dimensions button
Select the dimensions to associate to the elimination rule.