BeyondERP.Newsletter
Menu

Page · Consolidations

Elimination journal

A journal page, used in an elimination company, where elimination entries are proposed from elimination rules, reviewed and posted.

Used by
Chief financial officer, Accountant, Accounting manager and 2 more roles
Business process
Consolidate and eliminate financials
Menu item
LedgerJournalTable_Elimination
Main table
LedgerJournalTable
Data entity
None for this page's own settings
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 journal page, used in an elimination company, where elimination entries are proposed from elimination rules, reviewed and posted.
What you do hereUse this page to run an elimination proposal separately from the consolidation process, review the proposed amounts and post the journal.
ExampleFor example, BEAT's elimination company runs the elimination proposal for rule IC-SALES with the consolidation company as source for October 2026 with GL posting date 10/31/2026, and eliminates 15,000.00 of intercompany sales between legal entities A and B.
Elimination journal 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

Run and post the elimination proposal

Use this page to run an elimination proposal separately from the consolidation process, review the proposed amounts and post the journal.

Steps from Microsoft

  1. Go to Consolidations > Elimination journal.
  2. Create a journal and select the journal name.
  3. Select Lines.
  4. Select Proposals > Elimination proposal.
  5. Select the source company of the consolidated data and the elimination rule to process.
  6. Enter the start and end dates and the GL posting date, and then select OK.
  7. Review the amounts and post the journal.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
GL posting dateThe date used to post the elimination journal to the general ledger.Microsoft Learn 10/31/2026
Journal nameA journal name of type Elimination.Microsoft Learn ELIM
Source companyThe company that holds the consolidated data the proposal searches.Microsoft Learn The consolidation company
Elimination ruleThe active rule to process.Microsoft Learn IC-SALES
Start date / End dateThe dates searched for elimination amounts.Microsoft Learn 10/1/2026 to 10/31/2026

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
The amounts in the elimination journal are in an unexpected currencyThe elimination journal shows account amounts in the currency of their originating transactions, not in the accounting currency. Check them against that currency before you post. Microsoft Learn

Test checklist

  1. In the elimination company create a journal with a journal name of type Elimination and select Lines.
  2. Select Proposals > Elimination proposal, the source company, an active rule, the dates and the GL posting date.
  3. Check the proposed lines against the intercompany balances, then post.
  4. Check the trial balance of the elimination company shows the eliminated amounts.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run and post the elimination proposalRun the proposal in the elimination company after the consolidation, one rule at a time, and review the amounts before posting.Proposals give a reviewable journal, and the amounts show in the currency of the originating transactions.Eliminate during consolidation or with this journal?Running the proposal before the consolidation has brought the period's data into the source company.Test: Proposal eliminates intercompany amounts

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 accountant runs and posts the proposal; the controller reviews it. No Feature management feature is needed for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPosts in the elimination company: a legal entity with Use for financial elimination process selected; the proposal reads the source company you choose. Microsoft Learn
Can it be undoneHard to reverse: Review the proposed amounts before you post: posting writes the eliminations to the ledger of the elimination company. Microsoft Learn
If you change it laterPosting moves the eliminations into the ledger of the elimination company; the journal can post only to the Current layer, and its amounts show in the currency of the originating transactions. Microsoft Learn
Technical architect

6Technical

Menu itemLedgerJournalTable_Elimination Checked in Dynamics 365
FormLedgerJournalTable Checked in Dynamics 365
TableLedgerJournalTableShown as “LEDGER JOURNAL TABLE” in Record infoKey field: JournalNumChecked in Dynamics 365
Data entitiesLedgerJournalHeaderEntityLedger journal table (journal headers of the journal table that every journal type shares; elimination lines are created by the elimination proposal or the consolidation) Microsoft data model
Who can open itPrivilegesMaintain elimination journal transactions LedgerJournalTable_EliminationMaintainView elimination journal transactions LedgerJournalTable_EliminationViewDutiesMaintain closing transactions LedgerClosingTransactionsMaintainInquire into closing transaction status LedgerClosingTransactionsStatusInquire
5 security rolesChief financial officer CompanyChiefFinancialOfficerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialController
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounting supervisor LedgerAccountingSupervisorAccounting manager LedgerAccountingManagerAccountant LedgerAccountantTo use itChief financial officer CompanyChiefFinancialOfficerFinancial controller LedgerFinancialControllerGive people one of these roles. On this system, 5 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Lines, Validate, Post, Approval, PrintChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=LedgerJournalTable_Elimination
Data migrationLedgerJournalHeaderEntity (Ledger journal table): journal headers, per company.Load order: Elimination journals are created by the elimination proposal or during Consolidate online; open journals aren't moved, post or delete them before cut-over.Load first: Elimination rule, Journal namesMicrosoft Learn
Table definitionLedgerJournalTable columns and relations Microsoft data model
Everyone

8Sources