BeyondERP.Newsletter
Menu

Setup page · Consolidations

Elimination rule

A setup page where you define elimination rules that create elimination transactions in the destination (elimination) legal entity.

Used by
Auditor, Chief financial officer, Inventory accountant and 9 more roles
Business process
Consolidate and eliminate financials
Menu item
LedgerEliminationRule
Main table
LedgerEliminationRule
Data entity
LedgerEliminationRuleEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you define elimination rules that create elimination transactions in the destination (elimination) legal entity.
What you do hereUse this page to set, for each rule, the destination company, effective dates, active status and elimination journal name, and then the lines that pick source accounts and dimensions and the destination account and dimensions.
ExampleFor example, BEAT creates rule IC-SALES that posts to its elimination company with journal name ELIM, eliminating the net change of accounts 4* for Trading Partner values of the group companies.
Elimination rule 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.

Setup steps on this page

Set up Elimination rule

Use this page to set, for each rule, the destination company, effective dates, active status and elimination journal name, and then the lines that pick source accounts and dimensions and the destination account and dimensions.

Steps from Microsoft

  1. Go to Consolidations > Setup > Elimination rule.
  2. Create a rule and enter a description.
  3. Select the company that the elimination journal posts to.
  4. Set the effective and expiration dates, set Active to Yes, and select a journal name of type Elimination.
  5. Select Lines and choose to eliminate the net change amount or a fixed amount.
  6. Select the source accounts and set Account specification and Dimension specification.
  7. Select the source dimensions and values used as the source of the elimination.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Destination companyThe legal entity the elimination journal posts to; it must be set up for the financial elimination process.Microsoft Learn DestinationCompany
ActiveMakes the rule available in the elimination proposal process.Microsoft Learn Active
Journal nameThe journal name used for the elimination journal; it must be of type Elimination.Microsoft Learn JournalName
Elimination methodWhether a line eliminates the net change or a fixed amount.Microsoft Learn
Source accountThe source main accounts for the line; wildcards are allowed.Microsoft Learn
Account specificationWhether the destination uses the source main account or a user-defined destination account.Microsoft Learn
Dimension specificationWhether the destination uses the source dimensions or user-defined destination dimensions.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
The legal entity can't be chosen as the company the elimination journal posts toSelect Use for financial elimination process on that legal entity in Organization administration > Organizations > Legal entities. Microsoft Learn

Test checklist

  1. Check the destination legal entity has Use for financial elimination process selected and a journal name of type Elimination.
  2. Create the rule with Active = Yes and a line with source account (wildcards such as 1* are allowed) and the intercompany dimension value.
  3. In the elimination company open Elimination journal > Lines > Proposals > Elimination proposal, select the source company and the rule, and enter the date range and GL posting date.
  4. Check the proposed lines show the intercompany amounts on the expected destination accounts and dimensions, then post.
  5. Set Active = No and check the rule is no longer offered in the proposal.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Elimination ruleCreate a dedicated intercompany financial dimension (often called Trading Partner) and base the rule lines on it; post to a company with Use for financial elimination process selected, using a journal name of type Elimination.Learn advises a financial dimension created for elimination so intercompany amounts can be picked out; without one, you must rely on main accounts used only for intercompany transactions.How should each rule line pick the destination account and dimensions?Leaving Active at No, or picking a destination company or journal name that isn't set up for eliminations. A rule that isn't active isn't offered in the elimination proposal, so intercompany balances stay in the consolidated figures.Test: Elimination rule removes intercompany balances

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 designs the rules; accountants run them. No Feature management feature is needed for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: the Elimination rule entity is per company in Data management, and each rule posts to the destination company named on it. Checked in Dynamics 365
Can it be undoneReversible: Rules can be changed, deactivated or expired at any time. Changes apply to the next elimination proposal or consolidation run; journals already posted from the rule aren't changed. Microsoft Learn
If you change it laterA rule that is not active is not offered in the elimination proposal process. Microsoft Learn
Technical architect

6Technical

Menu itemLedgerEliminationRule Checked in Dynamics 365
FormLedgerEliminationRule Checked in Dynamics 365
TableLedgerEliminationRuleShown as “LEDGER ELIMINATION RULE” in Record infoChecked in Dynamics 365
Data entitiesLedgerEliminationRuleEntityElimination rule Microsoft data model LedgerEliminationRuleLineEntityElimination rule lines (the rule lines: method, source and destination accounts and dimensions, amount) Microsoft data model
Who can open itPrivilegesMaintain ledger elimination rules LedgerEliminationRuleMaintainView ledger elimination rules LedgerEliminationRuleViewDutiesInquire into general ledger policies LedgerGeneralLedgerPoliciesInquireEnable general ledger process LedgerGeneralLedgerProcessEnableInquire into general ledger policies RentalLedgerGeneralLedgerPolicieInquireEnable general ledger process RentalLedgerGeneralLedgerProcessEnable
12 security rolesAuditor AuditPolicyManagerChief financial officer CompanyChiefFinancialOfficerInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerRental coordinator agent RentalCoordinatorAgentRental manager RentalManagerRental purchasing manager RentalPurchasingManagerRental sales manager RentalSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounting supervisor LedgerAccountingSupervisorAccounting manager LedgerAccountingManagerRental sales manager RentalSalesManagerRental purchasing manager RentalPurchasingManagerRental manager RentalManagerTo use itAccountant LedgerAccountantChief financial officer CompanyChiefFinancialOfficerFinancial controller LedgerFinancialControllerAuditor AuditPolicyManagerInventory accountant clerk InventCostCostClerkGive people one of these roles. On this system, 12 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): LinesChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=LedgerEliminationRule
Integrate withLedgerEliminationRuleEntity data entity Microsoft data model
Data migrationLedgerEliminationRuleEntity (Elimination rule): per company.LedgerEliminationRuleLineEntity (Elimination rule lines): per company.Load order: Load Elimination rule before Elimination rule lines. Neither is in BEAT's configuration templates, so add them to a data project after legal entities, journal names, main accounts and financial dimensions.Load first: Legal entities, Journal names, Main accounts, Financial dimensionsChecked in Dynamics 365
Table definitionLedgerEliminationRule columns and relations Microsoft data model
Everyone

8Sources