BeyondERP.Newsletter
Menu

Report page · Inventory management

Potential conflicts - work in process and general ledger

A report that lists potential conflicts between work in process and the general ledger for a date interval.

Business process
Maintain inventory levels
Menu item
output:ProdWIPLedgerConflict
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 lists potential conflicts between work in process and the general ledger for a date interval.
What you do hereUse this report to look for potential conflicts between work in process and the general ledger, and to narrow the result by date, dimension name and value.
Potential conflicts - work in process 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 - work in process and general ledger
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 work in process balance in the ledger doesn't match production, during period-end reconciliation.
How oftenAt period end, and on demand when a work in process difference appears.
What the output showsPotential conflicts between work in process values and the general ledger for the period and dimension chosen. Unlike the inventory version, it compares work in process rather than on-hand inventory with the ledger.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Inquiries and reports > Inventory value reports > Potential conflicts - work in process and general ledger.
  2. Select a Date interval code, or enter the From date and To date for the work in process period.
  3. Switch Exclude physical to ledger to Yes if physical transactions posted to the ledger shouldn't be compared.
  4. Under Dimensions, select a Dimension name and enter the Dimension value to look at one dimension value at a time.
  5. Run the report and review the entries where work in process and the general ledger differ.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNothing to undo: The work in process conflicts report only compares data; it changes nothing. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:ProdWIPLedgerConflict 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:ProdWIPLedgerConflict
Everyone

7Sources