AED 400K in Dead Stock. 180 Days on the Shelf. Your Sales Team Wants More Budget.
AED 400,000 in dead stock. 180 days on the shelf. Zero movement. Your sales team asks for AED 200,000 in budget to acquire new inventory. The AED 400,000 already sitting in your warehouse is the budget they need.
The Math That Makes the Problem Visible
AED 400,000 in dead stock. 180 days on the shelf. Zero movement. Your sales team asks for AED 200,000 in budget to acquire new inventory. The AED 400,000 already sitting in your warehouse is the budget they need. They just cannot see it. Your total inventory is valued at AED 2.6M. 15.4% of it, AED 400K, has not moved in 180 days or more. That percentage is typical for trading companies in Dubai that do not run stock aging analysis. The industry average for healthy inventory turnover is 90 to 120 days. Anything beyond 180 days is capital wearing a costume. At a 6% cost of capital, holding AED 400K for 180 days costs AED 12,000 in financing charges alone. Add warehouse space allocation at AED 8 per square meter per month. If dead stock occupies 40 square meters, that is AED 320 per month or AED 1,920 over 6 months. Insurance on AED 400K of declared inventory adds roughly AED 2,000 per 6 months. Total holding cost: AED 15,920 for inventory generating zero revenue.
Breaking Down the AED 400K
Of the AED 400K, roughly 25% (AED 100K) is genuinely obsolete. Superseded models, expired certifications, or damaged packaging. This stock needs liquidation or disposal. Every day it sits, storage costs accumulate on an asset trending toward zero. 35% (AED 140K) is slow moving but viable. It could sell at a 20% to 30% discount. At a 25% markdown, you recover AED 105K. That AED 105K buys new, fast moving inventory with a 90 day turnover. In one cycle, the recovered capital generates AED 31,500 in gross profit at a 30% margin. In 180 days, the same capital turns twice, generating AED 63,000. The remaining 40% (AED 160K) is misallocated. These items sell in other locations, channels, or seasons. They are dead in your main warehouse because they were never moved to where demand exists. A stock transfer, not a write off, is the solution.
The System That Prevents the Next AED 400K
ERPNext generates stock aging reports that flag items approaching the 90 day mark. At 90 days, the system alerts your purchasing and sales teams. At 120 days, the item appears on a slow moving report visible to management. At 180 days, automatic markdown recommendations trigger based on your configured rules. An enterprise implementation configures aging thresholds, markdown policies, and inter warehouse transfer suggestions. The system does not wait for the annual stocktake to reveal dead stock. It shows you the problem while the stock still has 80% of its value, not after it has lost 50%. At AED 1,999 per month for the starter tier, stock aging analysis is included in the inventory module. The first report will show you exactly which products are sitting, how long they have been sitting, and what they are costing you per day. Log into your inventory system right now. Sort by last movement date. Filter for anything older than 120 days. Add up the total value. Divide by your monthly revenue. That ratio tells you how many months of sales revenue are locked in products nobody is buying. If the ratio exceeds 0.5, your dead stock is a bigger financial problem than any line item on your expense report.
Frequently Asked Questions
How does ERPNext identify dead stock automatically?
ERPNext tracks the last transaction date for every item. The stock aging report calculates days since last movement and groups items by aging brackets: 0 to 30, 31 to 60, 61 to 90, 91 to 180, and 180 plus days. Items exceeding your configured threshold are flagged automatically.
Can the system suggest what to do with slow moving stock?
With proper configuration, ERPNext can trigger workflow actions at different aging thresholds. At 90 days, generate a notification. At 120 days, suggest a markdown or inter warehouse transfer. At 180 days, recommend disposal review. Each threshold and action is configurable.
Does stock aging analysis work for businesses with seasonal products?
Yes. You can configure seasonal items with different aging thresholds that account for their natural buying cycle. A product that sells only in summer would have a longer acceptable aging window than a daily consumable.
Turn Dead Stock into Working CapitalWhen You are Ready,
We are Here.
Book a free inventory assessment. We will run a stock aging analysis on your data and show you exactly how much capital is trapped on your shelves.Book a free inventory assessment. We will run a stock aging analysis on your data and show you exactly how much capital is trapped on your shelves.