Best Practices in Inventory Turnover for the Modern Manufacturer

by | August 5, 2021 | Dynamics 365 for Finance and Operations

Improving inventory turnover is an ongoing process for all manufacturing operations. It is important to implement effective plans to optimize practices, ensuring you have the right level of inventory on your shelves at all times. Dynamics 365 can help you improve your inventory turnover process.

How to See Inventory Turnover in Dynamics 365

Inventory turnover is a financial ratio showing how many times a company has sold and replaced inventory during a given period. A company can then divide the days in the period by the inventory turnover formula to calculate the days it takes to sell the inventory on hand. Calculating inventory turnover can help businesses make better decisions regarding pricing, manufacturing, marketing, and purchasing new inventory. Companies must be able to move inventory, otherwise, it is incorrectly viewed as a fixed asset.

A slow turnover implies weak sales and possible excess inventory, whereas a faster ratio implies either strong sales or insufficient inventory. High volume, lower margin industries, such as retailers and supermarkets, tend to have the highest inventory turnover.


Selling Current Inventory

Distributed order management is a growing tool for businesses with multiple warehouses. In Dynamics 365, distributed order management profiles can be established with rules defining which warehouse a customer order will be shipped from. Orders can be fulfilled according to warehouse proximity, inventory levels, or inventory age. This improves supply chain efficiency and better meet customer expectations.

Downtime issues can be viewed in maintenance request management analytics. Knowing which machines have frequent downtime can impact how inventory is planned and stored.


Best Practices for Inventory Turnover with Dynamics 365

  • Set up your master plans and review them often – Review item master data, item coverage, and coverage groups on a regular basis and change if needed. A review plan should be in place and occur regularly.
  • Implement your forecast process – AI technology and algorithms in D365 help optimize forecasts with predictive analysis. This technology also allows users to make informed decisions based on past statistics.
  • Intercompany processing – Businesses across the world have stratified their production. With this approach, one area of the business will do something very well, as opposed to every part of the business attempting everything. Stratified production is part of an intercompany supply chain.
  • ABC analysis – ABC analysis allows managers to focus on what matters most. “A” parts constitute 20% of parts but 80% of output. “A” parts typically have a high cost, long lead time, are a tricky buy, and/or will halt downstream operations if supply runs out. These are the most crucial items to the production and distribution supply chain. “B” parts are less critical but still important. They either have a low cost or are easy to obtain. “C” parts are the least important, but they should still be regularly reviewed. “A” items tend to have high turnover rates whereas “C” items tend to have low turnover rates.
  • Cost administration functionality – The cost administration functionality gives users tools to analyze where inventory is, as well as insight into what must be done to move inventory. Within cost administration, inventory accounting status offers useful graphics and charts. Information on inventory accuracy, inventory turnover ratio, and days inventory on hand is all stored within inventory accounting status. This is helpful information when it comes to managing a balance sheet. Manufacturing accounting status, which is also under the cost administration functionality, shows the WIP turnover ratio.




Are you a manufacturer looking to get the most out of Dynamics 365? Reach out to us for help, or consider registering for our upcoming webinars.



Related Posts

  • *This post was written for Dynamics NAV but the content also directly applies to Dynamics 365 Business Central. You may notice some slight differences in the screenshots, but the information…

  • Dynamics 365 Finance and Supply Chain Management enables users to collect data from a variety of sources in order to analyze, summarize, and evaluate cost data. Cost data can then…

  • What are Inventory Dimensions in Dynamics 365 Supply Chain? When evaluating a new ERP platform, clients migrating from legacy systems that do not have the ability, or have limited ability…


Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events


01sep10:00 am10:30 amEnsuring Quality and Compliance for Batch Manufacturers in Life Sciences

01sep12:00 pm12:30 pmIs it Worth It to Move to the Cloud? A Look at Considerations for Current Agribusinesses Using Dynamics GP

01sep2:00 pm2:45 pmWhat’s New in Dynamics 365 Finance and Supply Chain

09sep11:00 am12:00 pmConfab Live with Stoneridge – Data Strategy and Reporting – Mining Decision Making Insights

15sep10:00 am11:00 amSolving the Biggest Challenges in Agribusiness Through Innovation and Technology

22sep12:00 am12:30 pmSimplifying Payroll and HR Management with ADP Workforce Now

22sep10:00 am10:30 amStreamlining Batch Manufacturing with Technology

22sep2:00 pm2:30 pmProcess Automation for Microsoft Dynamics D365 for Business Central, Finance and Operations and GP

23sep11:00 am12:00 pmConfab LIVE with Stoneridge - Riding the Wave 2 Release – Key Features Coming to Dynamics 365 this October

27sep(sep 27)9:00 am15oct(oct 15)11:00 amDynamics 365 Finance & Supply Chain Development Training - Online Workshop

29sep10:00 am11:00 amTop Five Reasons Why NOW is the Right Time to Move from Salesforce to Dynamics 365 Customer Engagement

29sep12:00 pm12:45 pmUnderstanding Job Costing and Tax Management in Business Central

29sep2:00 pm3:00 pmDigitalizing Horticulture & Agriculture - How to Sell Plants Online and Simplify Business Management

30sep12:00 pm4:00 pmSecurity and Permissions Training for D365 Business Central or Dynamics NAV


27sep(sep 27)9:00 am15oct(oct 15)11:00 amDynamics 365 Finance & Supply Chain Development Training - Online Workshop

06oct10:00 am10:30 amPreview of D365 Business Central Fall Release Features and Functionality

06oct12:00 pm12:30 pmInsider's Guide to New Features Available in the Fall Release of D365 Finance and Supply Chain

07oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Technical

21oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Functional

26oct(oct 26)9:00 am28(oct 28)5:00 pmStoneridge Connect Leadership and Community Conference

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!