Export (0) Print
Expand All

Set up elimination rules for transactions [AX 2012]

Updated: January 29, 2014

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.

NoteNote

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.

  1. Click General ledger > Setup > Posting > Ledger elimination rule.

  2. Click New to create a rule.

  3. Enter an identifier and a description for the elimination rule.

  4. In the Destination company field, select the legal entity where the elimination journal will be created.

  5. Enter or select the effective and expiration dates for the elimination rule.

  6. Select the Active check box to activate the elimination rule.

  7. In the Name field, select a journal name.

  8. Click Lines to create elimination rule lines.

  1. Click General ledger > Setup > Posting > Ledger elimination rule. Click Lines.

  2. Click New to create a line.

  3. Select the elimination method.

    • If you select Net change, go to step 4.

    • If you select Fixed amount, go to step 5.

  4. 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.

  5. 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.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft