The Manufacturing module has been a part of Navision/Dynamics NAV/Business Central since the mid 1990’s and one of the big mysteries is: Why do we not have a report showing exactly what went wrong in a production.
It is common knowledge that if the cost in a production has skyrocketed then there are only three possibilities for the failure:
- Too many components of changes of component prices
- Too many capacities added to the production as either consumed time or cost per produced unit.
- Too many capacities from subcontractors
But if I list, which reports exists for Business Central production orders, this is how it looks:
Here I can utilize the new (BC26.2) Finished Production Order Breakdown Power BI report:
The downside of the Power BI Reports is that all users that need to utilized the reports must have a paid Power BI Pro subscription.
The report resembles the Production Order Statistics Report from the Base Application that has always been there:
This report was until now the only report showing the expected and actual values of the production order.
If we look at the other reports available for production, then the list is short:
- Prod. Order Detailed Calculation
This will give an estimate in consumption of quantities and amounts and gives a good overview of the production as set up in the production order.
- Prod. Order – Precalculated Time
- Prod. Order – Components and Routing
- Prod. Order – Job Card
- Prod. Order – Picking List
- Prod. Order – Material Requisition
- Prod. Order – Order List
- Prod. Order – Shortage List
Of all these reports, the only ones that I have used are: 1) 6) and 8).
What do the production planner do if he/she wants to see exactly what was expected and what was actual in the production. Well, the only options are
- The Production Order Statistics Report
- The Production Order Statistics on the production card
- Or div into the Item Ledger entries or the Capacity Ledger entries to what went wrong.
The Final Costing Report
Many years ago, I started working on the Final Costing Report which look a lot like the Prod. Order Detailed Calculation report but now both with expected and actual data on it.
Let’s make an example, here is a Production Order for two levels:
- Finished Item
- Subassembly
The original routing and bill of materials looked like this:
For the routings, and the BOM for the finished item:
And the BOM for the subassembly:
However, during the production alternative operations and components were added and expected components and operations were skipped. That led to these Capacity Entires were created:
The blue capacity ledger entries represent the added capacities and the yellow marked capacity was not used.
Likewise in the components have extra components added to complete the production:
In order to make an overview of what went well and what went wrong, I created the Final Costing report. The report will include all lines in the production order showing one page per line.
- The expected and realized (Actual) quantities
- The expected and realized (Actual) amounts
- Work center 400 has been added since there are no expected values
- Work center 200 was expected but not used
- Cost price is always shown from the item card, because it is not possible to calculate the new inventory value of the subassembly, when it is added to inventory.
The report can be downloaded from here:
peikba/Production-Order-Final-Costing
