BeyondERP.Newsletter
Menu

Report page · Cost management

Materials in process

A report that prints the picking list transactions reported against current production orders as of a specified transaction date.

Business process
Print inventory costing reports in Dynamics 365 Finance
Menu item
output:ProdRawmaterialInProgress
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 prints the picking list transactions reported against current production orders as of a specified transaction date.
What you do hereUse this report to review the issued quantity and cost amount of components for production orders that have a status of Started or Reported as finished.
ExampleFor example, you can print the issued quantity of a component against the production orders that use it.
Materials in process 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 › Materials in process
Related pagesWork in process Microsoft Learn Indirect costs in process 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 itAt period end, or when you analyze material costs on current production orders before ending them.
How oftenMonthly, and on demand during production cost analysis.
What the output showsPicking list transactions per current production order: component, issued quantity and cost amount per transaction as of the date. Material that looks too high often belongs to orders already reported as finished, because those quantities aren't deducted.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Cost management > Inquiries and reports > Manufacturing accounting - status reports > Materials in process.
  2. In As on, enter the transaction date up to which picking list transactions are included.
  3. Filter in Records to include on a single component item when you want its issued quantity across all current production orders.
  4. Remember that only orders with status Started or Reported as finished are included, and the issued quantity isn't reduced by quantities reported as finished.
  5. Compare the total cost amount with the work in process balance for materials, keeping in mind that raw materials in process may be overstated.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
As onThe transaction date as of which the report lists the picking list transactions for current production orders.Microsoft Learn
Solution architect

4Design impact

Can it be undoneNothing to undo: The report only reads picking list transactions; it changes nothing. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:ProdRawmaterialInProgress 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 LedgerAccountingManagerProduction manager ProdProductionManagerChief executive officer CompanyChiefExecutiveOfficerGive people one of these roles. On this system, 6 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources