BeyondERP.Newsletter
Menu

Setup step on the Elimination rules definition report page · Consolidations

Document the elimination rules

Use this page to document and check the elimination rules before you run an elimination proposal or a consolidation with eliminations.

Business process
Consolidate and eliminate financials
Menu item
LedgerEliminationRulesReport
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that prints the elimination rules and their lines: the company each rule posts to, the journal name, the dates, whether it is active, and the source and destination accounts and dimensions.
What you do hereUse this page to document and check the elimination rules before you run an elimination proposal or a consolidation with eliminations.
ExampleFor example, before BEAT's first consolidation with eliminations the controller prints rule IC-SALES and checks it posts to the elimination company with journal ELIM and eliminates the net change of accounts 4*.
Elimination rules definition report page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itBefore the first consolidation with eliminations, after elimination rules change, and for audit documentation.
How oftenOn demand, whenever elimination rules are added or changed.
What the output showsA printout of the elimination rules and their lines: destination legal entity, journal, dates, active flag, source accounts and dimensions, and destination accounts. A rule missing from the printout is usually inactive or expired.

Source: Microsoft Learn

Setup steps on this page

Document the elimination rules

Use this page to document and check the elimination rules before you run an elimination proposal or a consolidation with eliminations.

Steps from Microsoft

  1. Go to Consolidations > Setup > Elimination rules definition report.
  2. Filter in Records to include on the elimination rules you want to document, for example only Active rules or one destination company.
  3. Run it and read for each rule the legal entity that the elimination journal posts to, the journal name, the effective and expiry dates, and whether it is Active.
  4. Review the rule lines: source accounts (with wildcards), the Account specification and Dimension specification (Source or User defined), and the net change or fixed method.
  5. Correct any rule that posts to the wrong accounts or company before you run an elimination proposal.

Source: Microsoft Learn

Common errors and fixes

MessageWhat to do
The elimination rule isn't offered in the elimination proposalSet Active to Yes on the rule and check the effective and expiration dates cover the proposal period. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Document the elimination rulesPrint the active rules before the first elimination run and after every rule change, and file the printout with the period close.A rule that posts to the wrong company or accounts is cheapest to find before the proposal runs.How are elimination rules approved?Printing without a filter and missing that a rule is inactive or expired.Test: Report lists active rules

Feature management and licence

Licence or add-inConsolidations is part of General ledger in Dynamics 365 Finance. In this system Accountant, Accounting manager, Accounting supervisor, Chief financial officer and Financial controller hold the consolidation duties. The controller and auditors read it. No Feature management feature is needed for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyThe elimination rules of the current company that match the filter in Records to include. Microsoft Learn
Can it be undoneReversible: The report changes no data.
If you change it laterNone on data; rerun it after any rule change, because it prints the rules as they are. Microsoft Learn
Technical architect

6Technical

Menu itemLedgerEliminationRulesReport Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itAccounting supervisor LedgerAccountingSupervisorAccountant LedgerAccountantAccounting manager LedgerAccountingManagerChief financial officer CompanyChiefFinancialOfficerFinancial controller LedgerFinancialControllerGive people one of these roles. On this system, 7 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=LedgerEliminationRulesReport
Data migrationLoad order: The Elimination rules definition report has no data entity in Data management, so it can't be loaded from a file or a configuration template. It is a report on the rules; move the rules themselves with the Elimination rule entities.Microsoft Learn
Everyone

8Sources

To cite this step: CON-SETUP-020, Document the elimination rules. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CON-SETUP-020