BeyondERP.Newsletter
Menu

Report page · Inventory 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
Maintain inventory levels
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 processMaintain inventory levels
Menu pathInventory management › Inquiries and reports › Inventory value 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 ledger trial balance and the inventory value don't match after inventory close, recalculation or a consistency check.
How oftenAt period end during reconciliation, and on demand when a difference appears.
What the output showsItems and transactions where the inventory value and the general ledger value differ for the period. If nothing is listed but balances still differ, rebuild the trial balance for the account first, as Microsoft suggests.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Inquiries and reports > Inventory value reports > Potential conflicts - inventory and general ledger.
  2. Select a Date interval code, or enter the From date and To date for the period you reconcile.
  3. In Main account, limit the report to the inventory ledger accounts you are reconciling.
  4. Switch Exclude physical to ledger to Yes to leave out physical transactions posted to the ledger, and Exclude blank dimension values to leave out transactions with empty dimension values.
  5. Under Dimensions, select a Dimension name and enter the Dimension value to narrow the result, then run the report and note the items that cause differences.
  6. For those items, run Inventory value report storage to trace the transactions behind each difference.

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 conflicts report only compares inventory and ledger data; it changes nothing. 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 itAccounting manager LedgerAccountingManagerInventory accountant clerk InventCostCostClerkInventory accountant InventCostAccountantChief executive officer CompanyChiefExecutiveOfficerAuditor AuditPolicyManagerGive 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