Skip to content
Production Order Analysis app iconProduction Order AnalysisFeature

Production Order Sales Margin for Microsoft Dynamics 365 Business Central

In make-to-order production, the question is not only what an order cost but whether the job made money, and answering it usually means matching production cost to the sales order by hand. Where a production order is linked to a sales order in Business Central, Production Order Analysis calculates the sales margin automatically and shows it beside the cost.

Cost and revenue for the same job sit on one worksheet.

How Production order sales margin works in Production Order Analysis

  1. A sales order is linked to the production order, as in make-to-order production.
  2. Production posts consumption, output, and capacity against the order.
  3. Open Production Order Analysis and select the production order.
  4. Read total cost, cost variance, sales amount, and gross margin on the same lines.
  5. Use the margin to review pricing and the jobs that underperformed.

Key capabilities

Margin from the linked sales order

When a production order is linked to a sales order, Production Order Analysis calculates the sales margin without any manual matching.

Cost and revenue side by side

Sales amount, gross margin, and gross margin percentage appear next to the rolled-up costs and total cost variance for each line.

In the report too

Turn on Show Sales and Margin Amounts in the Production Order Analysis report to include them. See Configurable Cost Summaries.

A profitability question

Cost shows what happened on the floor; margin shows whether it mattered for the job. Having both on one line turns a cost review into a profitability review.

See Production order sales margin on screen

Real screens from Production Order Analysis, shown with demo data.

Details that matter on the floor

Needs the sales order link

The margin appears only when the production order is linked to a sales order. Output made to stock and sold later has no linked sales order, so no margin is shown for it. Assembly orders linked to sales orders do not get a margin either.

Built on actual cost

Because the margin sits beside actual cost from posted entries, it settles along with the variance once the order is finished and cost adjustment has run.

Who uses Production order sales margin

Financial analysts

Evaluate how production orders actually performed and support pricing decisions.

Cost accountants

Tie production cost to revenue for margin analysis.

Production managers

See which jobs made the expected margin and which did not.

Questions about Production order sales margin

Can Business Central show the margin on a production order?

Yes, with Production Order Analysis, when the production order is linked to a sales order. Production Order Analysis calculates the sales margin automatically and shows it beside the cost.

What if we make to stock?

The margin needs a linked sales order. Without one, Production Order Analysis still compares actual and expected cost, but shows no sales margin.

Can the margin go in the report?

Yes. Turn on Show Sales and Margin Amounts in the Production Order Analysis report.

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 sales margin?

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