Standard Cost Updates in Business Central Manufacturing

Reading Time: 3 minutes

I’ll be honest with you. After 15 years on Business Central and NAV (and 30 in ERP overall) in factories across Greece and the UK, the one process that still causes more confusion, arguments, and financial headaches than almost anything else is the standard cost update.

I have seen companies go years without updating their standard costs because “it’s too complicated” or “we don’t want to create variances”. I have also seen companies rush the update without proper preparation and then spend weeks explaining massive unexplained variances to angry finance directors. Both approaches are painful.

Here is exactly how I handle standard cost updates in real projects. This is the practical method I use when I want the numbers to actually make sense.

Why Most Companies Get Standard Costing Wrong

Standard costing is not just a number on the Item Card. It drives inventory valuation, COGS, production variances, and margin reporting. When it is wrong, everything downstream is wrong.

The biggest mistake I see constantly in manufacturing companies is treating standard cost updates as a simple “run the worksheet and click OK” exercise. It is not. If your work centres have outdated rates, your BOMs have wrong scrap percentages, or your routings are based on wishful thinking, the roll-up will give you garbage, and you will pay for it every month-end.

For most discrete and repetitive manufacturing, I strongly believe Standard Cost is the right choice. It gives you clean variance analysis and predictable costing. Average Cost hides problems. FIFO is fine for trading companies but usually too detailed for production.

My Real-World Process for Standard Cost Updates

Before I touch anything, I make sure the foundation is solid. I check that work centre and machine centre rates are current. I walk the shop floor with the production manager to verify that routings reflect reality, not the ideal times someone wrote five years ago. I review BOMs for missing components or incorrect quantities.

Only then do I create a new costing version (I usually call it something like “2026 Mid-Year Update”) so we have a clear audit trail.

I open the Standard Cost Worksheet, select the new version, filter the items, and run Calculate Standard Cost. Then comes the part most people skip: I sit down and review every suggested change. Zero costs, huge jumps, missing subcontracting, I want to see all of it.

When I’m happy, I run Implement Standard Cost Changes. Finally, I change the costing version status to Active. At that moment the new costs become live.

Business Central immediately creates revaluation entries for every unit you have in stock. If an item’s standard cost moves from £25 to £30 and you hold 100 units, you get a clean +£500 revaluation. Simple, transparent, and fully traceable.

The Mistakes I See Constantly (and How to Avoid Them)

• Updating BOM costs manually instead of letting the worksheet do it. This almost always creates inconsistencies.
• Running the update in the middle of the month. This mixes old and new costs and makes variances impossible to explain.
• Forgetting to update work centre rates before the roll-up. This is the silent killer of accurate costing.
• Applying costs without reviewing the worksheet suggestions. I have seen this create chaos more than once.

Best Practices I Always Insist On

I always test the entire process first in a sandbox. I freeze BOM and routing changes during the review period. I make sure both production and finance teams know the update is coming. In most companies I recommend doing a full standard cost update at least twice a year, once at the start of the financial year and once mid-year if raw material prices have moved significantly.

Final Thoughts from the Field

Standard cost updates are not a boring administrative task. When done properly, they become one of the most powerful tools you have for cost control and profitability analysis. When done badly, they create months of confusion and distrust between production and finance.

If you treat the process with the respect it deserves (good master data, proper review, and clear communication) you will get clean, reliable numbers that actually help the business.

If you are planning a standard cost update soon and want to avoid the usual disasters, feel free to reach out. I have done this many times in both Greek and UK factories, and I am happy to share more details from real projects.