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 it
When the trial balance and the inventory value still differ after closing, recalculation or reverse, and rebuilding the trial balance didn't help.
How often
On demand during month-end reconciliation.
What the output shows
Items 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.
Go to Cost management > Inquiries and reports > Inventory accounting - status reports > Potential conflicts - inventory and general ledger.
Select a Date interval code, or enter the From date and To date of the period that doesn't reconcile.
In Main account, select the inventory ledger account whose balance differs from the inventory value.
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.
Take the items listed as conflicts, run an inventory value report for them, and run the consistency check before you close inventory again.
The ledger account whose transactions are included.Microsoft Learn
Exclude physical to ledger
Leaves out physical inventory transactions that were posted to the ledger.Microsoft Learn
Exclude blank dimension values
Leaves out transactions that have empty dimension values.Microsoft Learn
Solution architect
4Design impact
Can it be undone
Nothing 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 item
output:InventLedgerConflictChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To 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