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
- A sales order is linked to the production order, as in make-to-order production.
- Production posts consumption, output, and capacity against the order.
- Open Production Order Analysis and select the production order.
- Read total cost, cost variance, sales amount, and gross margin on the same lines.
- 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.
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 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.
