Skip to content
Production Order Analysis app iconProduction Order AnalysisFeature

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

  1. Open the Production Order Analysis Worksheet.
  2. Enter the status, number, and line number of the production order.
  3. Read the totals panel for expected cost, actual cost, and variance by cost type.
  4. Scroll across the lines for quantities, times, costs, and margin.
  5. 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.

Production Order Analysis app icon

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.

Ask a product question

Product Questions