Dead stock is inventory that has not sold within a business's normal trading cycle and is unlikely to sell without significant price reduction or intervention. It differs from safety stock, which is held deliberately, and from slow-moving stock, which still turns over at a reduced rate. Dead stock ties up working capital, occupies warehouse space and, if left unmanaged, may need to be written down or disposed of at a loss. Microsoft Dynamics 365 Business Central provides the reporting tools to identify dead stock before it becomes a significant balance sheet or cash flow problem.
How Business Central helps identify dead stock
Business Central's inventory ageing and item turnover reports show stock levels alongside sales history, giving buyers and finance teams visibility of items that are accumulating without moving. The item ledger records every transaction against each item, providing a complete history of receipts, sales and adjustments. For more sophisticated dead stock analysis, Power BI connected to Business Central can segment inventory by days since last sale, calculate the carrying cost of each dead line and rank items by the working capital they are tying up.
Dead stock in practice
- A distributor runs a quarterly dead stock report in Business Central and identifies 340 lines with no sales in the past 12 months, worth £180,000 at cost. The buying team clears them through promotional pricing before year-end.
- A finance director uses Power BI connected to Business Central to calculate the annual carrying cost of slow and dead stock, presenting the case for tighter reorder point discipline to the board.
- A purchasing manager sets a rule in Business Central to flag any item that reaches 180 days without a sale as requiring review before any further purchase orders are placed.
- A business writes down dead stock via an item journal in Business Central, posting the difference between cost and net realisable value to a stock provision account in the general ledger.
How Advantage helps manage dead stock
Advantage builds dead stock and inventory ageing reports in Business Central and Power BI as part of implementation, giving distribution businesses the visibility they need to act on excess stock before it becomes a write-off. We also advise on item planning parameters to reduce the conditions that create dead stock in the first place.
Frequently Asked Questions
Common questions about dead stock and inventory management in Business Central.