Cost Roll-Up Details on the Item Card
Here is a super simple, but very useful modification for displaying the rolled-up costs on the item card in Microsoft Dynamics NAV. The item table has 10 standard fields that contain the rolled-up costs that are calculated during a regular standard cost roll-up. Those fields are not by default added to the item card; just adding them is quick and adds lots of values to the users that are looking at the costs shares of items.
The 10 fields are called: Single-Level Material Cost, Single-Level Capacity Cost, Single-Level Subcontrd. Cost, Single-Level Cap. Ovhd Cost, Single-Level Mfg. Ovhd Cost, Rolled-up Material Cost, Rolled-up Capacity Cost, Rolled-up Subcontracted Cost, Rolled-up Mfg. Ovhd Cost and Rolled-up Cap. Overhead Cost
Here is how to add them to the item card:
Open the item card (page 30) in design mode using the development environment, add a group for a new FastTab (I called it Cost Roll-Up) and add the above fields. Close and save the page, that’s it! 🙂
Now when you open the item card you see the cost roll-up broken down by the different costs directly on the item card without running a report or open another page.
The fields are updated by Dynamics NAV when you do a standard cost roll-up and are by design non-editable.
Simple and clean.
Note; even if you are not using the standard costing method, you can still run a cost roll-up to get those fields populated. The fields are used in some of the reports as well; like the rolled-up cost shares and the single level cost shares reports. And they are also used on the statistic page of a production order.