BeyondERP.Newsletter
Menu

Report page · Cost management

Potential conflicts - inventory and general ledger

A report that shows differences between inventory transaction values and general ledger transaction values for a period.

Business process
Print inventory costing reports in Dynamics 365 Finance
Menu item
output:InventLedgerConflict
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that shows differences between inventory transaction values and general ledger transaction values for a period.
What you do hereUse this report to reconcile inventory with the general ledger and find the items that cause differences.
ExampleFor example, if the trial balance differs from the inventory value after closing, you can run this report to trace the items that cause the conflict.
Potential conflicts - inventory and general ledger 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

Business processAnalyze financial performance › Analyze costs › Print inventory costing reports in Dynamics 365 Finance
Menu pathCost management › Inquiries and reports › Inventory accounting - status reports › Potential conflicts - inventory and general ledger
Related pagesInventory value Microsoft Learn
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 itWhen the trial balance and the inventory value still differ after closing, recalculation or reverse, and rebuilding the trial balance didn't help.
How oftenOn demand during month-end reconciliation.
What the output showsItems and transactions where the inventory value and the general ledger value differ for the period and account. Each line points to an item to investigate; manual ledger postings to inventory accounts often show up here.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Cost management > Inquiries and reports > Inventory accounting - status reports > Potential conflicts - inventory and general ledger.
  2. Select a Date interval code, or enter the From date and To date of the period that doesn't reconcile.
  3. In Main account, select the inventory ledger account whose balance differs from the inventory value.
  4. Switch Exclude physical to ledger and Exclude blank dimension values to Yes to leave out physical postings or transactions without dimension values; under Dimensions, pick a Dimension name and value to narrow further.
  5. Take the items listed as conflicts, run an inventory value report for them, and run the consistency check before you close inventory again.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Main accountThe ledger account whose transactions are included.Microsoft Learn
Exclude physical to ledgerLeaves out physical inventory transactions that were posted to the ledger.Microsoft Learn
Exclude blank dimension valuesLeaves out transactions that have empty dimension values.Microsoft Learn
Solution architect

4Design impact

Can it be undoneNothing to undo: The report only compares inventory and ledger data; it changes nothing. Its stored data can be removed with the matching cleanup job. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:InventLedgerConflict Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccounting manager LedgerAccountingManagerChief executive officer CompanyChiefExecutiveOfficerAccounting supervisor LedgerAccountingSupervisorGive people one of these roles. On this system, 9 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=output:InventLedgerConflict
Everyone

7Sources