Production Order Analysis Worksheet for Microsoft Dynamics 365 Business Central
Reviewing the cost of a production order in Business Central often means moving between statistics, ledger entries, and reports to piece the picture together. Production Order Analysis brings that detail into one worksheet, the Production Order Analysis Worksheet: quantities, times, costs, variances, and margin.
A report with the same figures can be opened from the worksheet.
How Production Order Analysis worksheet works in Production Order Analysis
- Open the Production Order Analysis Worksheet.
- Enter the status, number, and line number of the production order.
- Read the totals panel for expected cost, actual cost, and variance by cost type.
- Scroll across the lines for quantities, times, costs, and margin.
- Open the report if you need a printed or shared version.
Key capabilities
Select the order
Choose the production order by status, number, and line number in the worksheet header.
A line for every part of the order
The worksheet lists the parent item, its components, and the work centers on its routing, each with its own figures.
Totals at a glance
A Total Costs panel shows material, capacity, subcontracted, capacity overhead, and total cost, expected and actual, with the variance for each.
Everything on the row
Quantities, setup and run times, material cost, rolled-up costs, and margin sit on the same row for each line, so nothing has to be cross-referenced.
Report from the worksheet
The Production Order Analysis Report action opens the report, where you choose which summaries to include. See Configurable Cost Summaries.
See Production Order Analysis worksheet on screen
Real screens from Production Order Analysis, shown with demo data.
Details that matter on the floor
Calculated on demand
The worksheet works from posted entries and is calculated when you use it, so it reflects the latest posting rather than a stored snapshot.
Who uses Production Order Analysis worksheet
Cost accountants
Review production order cost in one place instead of across several reports.
Production managers
Check an order's quantities, times, and costs together.
Questions about Production Order Analysis worksheet
Is there one place in Business Central to review production order cost detail?
Yes, with Production Order Analysis. The Production Order Analysis Worksheet shows quantities, times, costs, variances, and margin for a production order on one page.
Can I print the analysis?
Yes. Open the Production Order Analysis report from the worksheet and choose the summaries to include.
Does the worksheet change any data?
No. Production Order Analysis reads posted entries; it does not change standards, routings, or bills of materials.
Related Production Order Analysis features
All Production Order Analysis features →Part of Production Order Analysis
Monitor actual vs. expected production costs to optimize budgets and enhance profitability.
Have a question about Production Order Analysis worksheet?
Send us a note and the Production Order Analysis team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
