5 Best Practices for Inventory Control in Business Central

By Rob Jolliffe | July 17, 2019
4 min reading time

Manufacturing companies often struggle with Inventory Control in Business Central. There are many ways that inventory control can become a problem, but the results are almost always the same.  Stock outs on critical parts; customer deliveries delayed; frustration and finger pointing between staff; rescheduled production and constant expediting.  These are all signs of Inventory Control that's not at all in Control in your Business Central database. 

There are some critical best practices when implementing inventory control in Business Central systems that might point to the problem or solution depending on where you currently stand. 

inventory control in business central

#1 Bills of Material

Manufacturing companies need Bills of Material (BOM) and they have to be very accurate. Small errors in a Bill of Material for high volume production parts can lead to huge errors in your inventory.  Be sure your BOM's are accurate and managed by your engineering team. 

#2 Units of Measure

Business Central contains Unit of Measure (UM) conversion rules.  If the UM conversion for a Pound to a Kilogram is 2.0 instead of 2.2 or 2.2046 that can have a significant impact on inventory levels depending on your business. Make absolutely sure all your Units of Measure are right!  Don’t forget to adjust prices based on Units of Measure too! These are critical pieces of information required for proper inventory control in Business Central.

#3 Lengths to Weight

At Sabre, we work with a lot of manufacturing companies. Most of these companies use some kind of product that has a conversion between pieces and weight. This can be the M-Weight of paper delivered in sheets, or it can be the weight of a length of steel bar stock intended to be run on a lathe.

For these customers, even more, important than the other Units of Measure are length to weight conversions.  If 12 inches of a 1-inch diameter Cold Rolled Steel bar is 2.670 Pounds per foot, make 100% sure that is recorded correctly your inventory control in Business Central records. Otherwise, you are guaranteed to have problems. 

#4 No Adjusting Entries

All inventory control in Business Central errors is caused by a mistake in base data (like the Bill of Material or Unit of Measure above) or an error in manufacturing staff data entry.  Find the missing transaction or correct the BOM or U of M - do not make adjusting entries.  Limit this to a small group of staff who need to justify their adjustment.  Make it hard to adjust - then people will do the right thing. 

Do NOT make adjusting entries. In case you didn't hear me the first time!

#5 Culture of Discipline

Make sure your manufacturing staff has a culture of discipline.  This should come from the top down.  Staff who make errors should be given some remedial help, reprimanded if they are being careless, and pruned from your payroll if they just won't get on board.  

Once you start to get that culture of discipline, and inventory control in Business Central is under control, then it might make sense to start looking at Barcode Warehouse Management, but even this technology can have it's problems.

Inventory Management in Business Central Conclusions

Your inventory is your lifeblood. All your staff and management need to take it incredibly seriously. There are a number of best practices that are necessary for managing inventory and ensuring it is accurate. These are just a few of the best practices we think are worth discussing as we see them regularly.

Need Some Help?

If you need help with a Dynamics 365 Manufacturing systems choice Inventory Management in Business Central or any other questions, give us a call at: (519) 585-7524 x.45 or contact our team, we're excited to talk with you soon!

You can also check Rob Jolliffe's LinkedIn articles here.

Rob Jolliffe

Robert has been a Dynamics 365 Business Central consultant since 2008 and a general manufacturing consultant for over 25 years. He is a graduate of the University of Toronto mechanical engineering program where he focused on production engineering. In addition to a deep knowledge of Manufacturing Robert holds a Microsoft Systems Engineer designation and is much less of an expert in Networking and IT infrastructure than he thinks, but is still pretty good. He also has applied his engineering skills to learning programming, and is warned frequently by the professional developers who work for him that he is pretty good, but don't write any code for customers without letting them check it.

Related posts

PrintVis For Commercial Print| The Microsoft Dynamics Addon Graphics Manufacturing Industry

The PrintVis MIS solution for the commercial printing industry is an end to end powerhouse solution This is an article […]
December 9, 2020

Everything you Need to Know About Microsoft Dynamics 365 Business Central Manufacturing Modules

Over the last decade the manufacturing sector has undergone major changes in North America. There is always increased pressure from the likely sources - all the while customers are demanding faster delivery and more competitive prices at a higher level of quality and more and more product variation and innovation.
October 14, 2020

Better Purchasing through ERP Implementation in Manufacturing

I have worked with a lot of companies that manage their purchasing in a variety of ways. It’s always part of any ERP project to help them improve purchasing management practices, and in particular improve their efficiency and accuracy. This is a major part of any ERP implementation in manufacturing businesses.
October 2, 2019
Copyright © 2022 SabreLimited.com