Managing Obsolete and Slow-Moving Stock: A Practical ERP Approach

Overview

This post looks at how manufacturers and distributors can spot obsolete and slow-moving stock before it drains margin. It covers why the problem builds up, how Business Central flags at-risk inventory, and sets out a practical process for write-down, clearance and prevention.


 

What Counts as Obsolete or Slow-Moving Stock 

Obsolete stock is inventory that no longer has a market. Slow-moving stock still sells, but far too slowly to justify the space it occupies. Both tie up cash that could fund growth elsewhere. Manufacturers and distributors often discover the scale of the problem only at year-end stocktake. 

Common causes include discontinued components, seasonal ranges that missed their window, and forecasting errors. Engineering changes can also strand raw materials overnight. When a bill of materials changes, older parts sometimes have no remaining use. Left unmanaged, this stock sits on the balance sheet indefinitely. 

Some businesses also carry stock that was ordered in the wrong quantity rather than the wrong item. A single bulk discount from a supplier can leave a warehouse holding years of supply. Because that stock still sells occasionally, it rarely gets flagged as a problem. So it quietly ties up space and cash for far longer than anyone planned. 

 

Why Excess Stock Costs More Than You Think 

Holding cost is not just the purchase price of an item. Warehousing, insurance, handling and the risk of damage all add up over time. Panorama Consulting Group’s research on ERP outcomes consistently links better inventory visibility to lower carrying costs, although the scale varies by sector. So the true cost of obsolete stock is higher than most finance teams assume. 

Dead stock also distorts reporting. Inflated inventory values overstate asset health to lenders and investors. Write-downs, when they finally happen, hit profit in one uncomfortable move. Proactive management protects both cash flow and reporting accuracy. 

There is also an opportunity cost to consider. Every square metre used for slow-moving items is a square metre unavailable for stock that actually turns. Working capital locked in dead inventory cannot fund new product lines or better supplier terms. That makes obsolete stock a strategic issue, not just a warehouse one. 

Staff time adds a further hidden cost. Every cycle count, every relocation and every write-down review takes hours away from more productive work. Because that time is rarely tracked against specific items, it stays invisible on any report. Even so, it remains a real drain on a lean operations team. 

 

How Business Central Flags Slow-Moving Items

Microsoft Dynamics 365 Business Central gives visibility that spreadsheets cannot match. The system tracks turnover rates, last sale dates and stock ageing by item and location automatically. Tecvia configures these views as part of every Business Central inventory management implementation. That means slow movers surface long before they become dead stock. 

Item tracking by lot and serial number adds another layer of insight. When a batch approaches its use-by date or has not moved in months, the system flags it directly. Purchasing then sees the same data, which means reorder suggestions adjust automatically. Nobody keeps ordering stock nobody is using. 

Dashboards built on this data give managers a single view across every location. So a director can compare ageing stock in Manchester against a second warehouse in minutes. This visibility replaces the manual spreadsheet exports that many finance teams still rely on. It also means slow-moving stock becomes visible to everyone, not just the warehouse team. 

 

Building a Practical Write-Down and Clearance Process 

A clear policy turns occasional stocktake surprises into routine housekeeping. Start by defining ageing thresholds, for example ninety, one hundred and eighty, and three hundred and sixty days without movement. Items crossing each threshold get flagged for review automatically inside Business Central. This removes the guesswork from deciding what counts as slow-moving. 

Once flagged, give each item an action: discount, bundle, return to supplier or write down. Sales and purchasing teams should review flagged items monthly, not just at year-end. Because Business Central links inventory data to financial postings, write-downs update the general ledger without manual journals. That keeps management accounts accurate throughout the year, not just after an audit. 

Assign clear ownership for each stage of this process. A single person or small team should approve write-downs, so decisions stay consistent across the business. Without ownership, flagged items often sit untouched for months. Clear accountability, on the other hand, keeps clearance moving and prevents stock from ageing further. 

Distributors face this challenge just as often as manufacturers. Wholesale businesses that buy in bulk can see clearance decisions affect margin on an entire product line at once. Our distribution and wholesale ERP page covers how Business Central supports stock control across multiple depots and locations. 

 

Preventing Future Stock Build-Up 

Better forecasting stops the problem recurring. Business Central’s demand planning tools use historical sales and lead times to suggest realistic order quantities. Reviewing minimum and maximum stock levels each quarter keeps them in line with actual demand. Manufacturers in particular benefit, since bills of materials often hide the true cost of an obsolete component, a theme covered in our guide to manufacturing ERP systems. 

Industry benchmarking also helps. Businesses in manufacturing and engineering face particular stock risk from engineering changes and long lead times. That is why our manufacturing and engineering ERP page sets out sector-specific controls. For a wider view of how ERP connects finance, purchasing and stock control, see our overview of what an ERP system does. 

Supplier collaboration matters too. Sharing forecasts with key suppliers reduces the risk of large, speculative orders that later turn into dead stock. When suppliers understand real demand, they can offer smaller, more frequent deliveries instead. Together, these tools turn reactive firefighting into planned, routine stock control. 

Culture plays a role as well. Teams that treat stock accuracy as everyone’s job, not just the warehouse manager’s, catch problems earlier. Regular training on how to read Business Central’s ageing reports helps that culture take hold. After a few months, most teams find flagging slow stock becomes second nature rather than an extra task. 

 

Ready to Get Slow-Moving Stock Under Control? 

Obsolete and slow-moving stock rarely fixes itself. The right ERP setup gives you the visibility and automation to catch it early. Tecvia’s consultants can review your current stock data and show you where Business Central would flag risk today. Book a consultation with our team to see a live demonstration tailored to your business. 

FAQs

For anything not covered here, get in touch directly. We’re happy to answer questions specific to your business and your ERP requirements.

Business Central tracks last sale date, turnover rate and stock ageing for every item automatically. You can set ageing thresholds so items crossing them get flagged for review. This turns obsolete stock identification into a routine report rather than a manual stocktake exercise. 

Obsolete stock has no remaining market and will not sell at any price. Slow-moving stock still sells, but turnover is far below target, tying up cash and space. Both need different treatment. Obsolete stock usually needs writing off, while slow-moving stock can often be discounted or bundled. 

Monthly reviews work well for most manufacturers and distributors. Waiting until year-end stocktake means problems build up unnoticed for months. Because Business Central automates the flagging, a monthly review takes far less time than a manual spreadsheet exercise. 

Yes. When you write down an item’s value, Business Central posts the adjustment directly to the general ledger. This removes the need for manual journal entries and keeps management accounts accurate throughout the year. 

Forecasting errors, engineering changes and seasonal demand shifts are the most common causes. A bill of materials change can strand components that once had a clear use. Regular reviews inside Business Central catch these items before they become a larger write-off. 

Wholesale businesses often buy in bulk, so a single poor purchasing decision can affect an entire product line. Multiple depots also make it harder to spot ageing stock without a connected system. Business Central gives a single view across every location, which means clearance decisions happen faster. 

Picture of Author: Saima Bhad

Author: Saima Bhad

Saima is a digital marketer with a focus on content and social media. She writes regularly on business technology topics, with a particular focus on how ERP solutions like Microsoft Dynamics 365 Business Central help growing businesses work more efficiently.

Latest Articles