Batch & Expiry Management: The War Against Capital Evaporation
With 20 years in ERP/SCM, I've seen billions vanish due to poor Batch & Expiry tracking. Here is the strategic fix.
After 20 years of deploying ERP and SCM systems for top-tier distribution corporations in Vietnam, I have witnessed billions of VND ‘evaporate’ due to a fundamental mistake: managing Batch and Expiry Dates based on intuition rather than data.
Many CEOs still think of a warehouse as a storage space. They are wrong. A warehouse is cash, and expired-date goods are ‘melting’ money.
1. Batch & Expiry: The ID Card of Goods
If you don’t manage by Batch, you are running a ‘messy pot.’ When a quality issue occurs or a recall is mandated (especially in Pharma and FMCG), failing to trace which batch was imported when and where it went is a legal and reputational disaster.
“Managing inventory without Batch tracking is like driving in fog without headlights. You only know you’ve hit a wall when it’s too late.”
2. FEFO Strategy - The Ultimate Survivor
In professional distribution, FIFO (First In, First Out) is basic, but FEFO (First Expired, First Out) is the gold standard. Why? Because goods imported later might have a shorter shelf life than those imported earlier. If the system doesn’t automatically suggest picking by FEFO, warehouse staff will always grab the nearest pallet. Result: Goods buried deep in the corner expire and become financial waste.
| Comparison Metrics | Manual Management (Excel) | ERP-Driven (Optimization) |
|---|---|---|
| Retrieval Speed | 2-4 hours (Manual search) | < 5 seconds (Real-time) |
| Write-off Rate | 3% - 7% of revenue | < 0.5% of revenue |
| Traceability | Fragmented, error-prone | 100% accurate per SKU |
| Cash Flow | Stuck in aging stock | Optimized turnover |
3. The Perspective of a Management Expert
As I expanded into Real Estate and Insurance, the systemic mindset of Expiry Dates remained vital.
- In Insurance: Every policy is a time-bound entity. Managing renewals is like managing product expiry. Missing a ‘date’ means losing a client and their premium flow.
- In Inventory: Short-dated stock is a high-risk asset. A sharp Risk Management expert must offload these via promotions before they turn into disposal costs.
Real-world Lesson in the Vietnam Market
I once saw a major FMCG firm in Central Vietnam nearly go bankrupt because their legacy accounting system couldn’t track batches. During a surprise audit, 40% of their stock had less than 15 days of shelf life. Supermarkets rejected the shipments. It was a costly lesson in neglecting Master Data and Inventory Control.
Tuong’s Advice: Don’t wait until your warehouse stinks to find a solution. Tighten your Batch Management from the point of entry. An ERP system isn’t just for tax reports; it’s a weapon to protect every cent of your capital.
Nguyen Manh Tuong
Systems & Financial Management Expert.