BeyondERP.Newsletter
Menu

Report page · Cost 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
Print inventory costing reports in Dynamics 365 Finance
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 processAnalyze financial performance › Analyze costs › Print inventory costing reports in Dynamics 365 Finance
Menu pathCost management › Inquiries and reports › Manufacturing accounting - status 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 itAt period end, when the WIP ledger account differs from the WIP value of production orders.
How oftenOn demand during month-end WIP reconciliation.
What the output showsProduction transactions where the work in process value and the general ledger differ for the period. Unlike the inventory version of this report it looks at WIP, so differences often come from manual postings to WIP accounts or orders posted with other ledger settings.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Cost management > Inquiries and reports > Manufacturing accounting - status reports > Potential conflicts - work in process and general ledger.
  2. Select a Date interval code, or enter the From date and To date of the period whose WIP balance doesn't reconcile.
  3. Switch Exclude physical to ledger to Yes to leave out physical postings when only financial WIP should be compared.
  4. Under Dimensions, select a Dimension name and enter the Dimension value to narrow the comparison to one site or department.
  5. Investigate the production orders listed, then compare the WIP ledger account with the WIP column of an inventory value report for the same dates.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNothing to undo: The report only compares WIP and ledger 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 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:ProdWIPLedgerConflict
Everyone

7Sources