Skip to content

Unexpectedly High New Standard Cost in Microsoft Dynamics NAV

ArcherPoint How-To Blog: Step-by-step instructions on how to perform specific tasks in Microsoft Dynamics NAV

There are times when you are using the Dynamics NAV Standard Cost Method and rolling up a Standard Cost for a Produced Item you get an unexpectedly high Standard Cost.

A probable cause is that you have selected "Cost Includes Setup" in the Manufacturing Setup and that you have a setup time in a Routing Line but forgot to enter a value for ‘Lot Size’ on the item card.

Checking or unchecking the “Cost Includes Setup” in the Manufacturing Setup window can affect Standard Cost

Figure 1 – Checking or unchecking the “Cost Includes Setup” in the Manufacturing Setup window can affect Standard Cost

From the Dynamics NAV Help for Lot Size on the Item Card:

If the item routing includes fixed costs such as setup time, then the value in this field is used to calculate the standard cost price and distribute the fixed costs of manufacturing the item.

Here is the Routing for the Bicycle Item 1000 that shows Setup Time in the Routing.

Setup Time in the Routing table

Figure 2 – Setup Time in the Routing table

When we roll up the standard cost for Item 1000 with the Lot Size set to zero, we get $533,399.

Setting the Lot Size to zero…

Figure 3 – Setting the Lot Size to zero…

…yields a Standard Cost of $533,399

Figure 4 – …yields a Standard Cost of $533,399

When we set the Lot Size to 10, I get a Standard Cost of $383.099

Setting the Lot Size to 10…

Figure 5 – Setting the Lot Size to 10…

…yields a Standard Cost of $383,099

Figure  6 – …yields a Standard Cost of $383,099

For more information on this or any other Dynamics NAV topic, please contact ArcherPoint.

For more step-by-step instructions on how to perform specific tasks in Microsoft Dynamics NAV, see our collection of How-To blogs.

Read ArcherPoint's Blog Follow us on Twitter Follow us on Facebook Follow us on LinkedIn Link to our RSS feed Join us on Google+ Watch us on YouTube
Get Help Now