Insights
Materials left to expire in their sacks! Plugging raw material leaks and tracing production lots with ERP
blog
“Warehouse staff always send the line whichever pallet is ‘at the front and easiest to reach,’ and that is usually the stock the supplier delivered only yesterday! Older lots get pushed further and further to the back of the warehouse… Then, during the big year-end clean-out, you discover that chemicals and flour worth several hundred thousand baht have ‘expired on the pallet’ and have to be hauled away for disposal. Worse still, when a customer complains about a product, QC has to spend a week digging through piles of paperwork to work out which bags of material went into that lot!”
If this sounds familiar, your factory is facing one of the most serious gaps in any supply chain: lot blindness.
In industries where products have a limited shelf life, such as food, pharmaceuticals, chemicals, and even rubber and plastic parts, managing stock by eye or with paper labels on the bags leads to hidden waste and legal risks that can bring a business down overnight.
The nightmare of a factory without lot/batch control
Leaving material issue to chance leads to a double disaster that destroys both profit and reputation:
- The “first in, still there” phenomenon: Without a system telling them what to pick, staff naturally work on a LIFO (last in, first out) basis. Older materials expire in the warehouse, become a sunk cost, and then incur additional industrial waste disposal costs on top.
- The product recall nightmare: If lot X of a supplier’s material turns out to be contaminated, but the factory has no record of which finished-goods lots it went into, you may be forced, as a precaution, into a mass recall worth tens of millions of baht, instead of recalling just the few hundred cartons from the affected lots!
From risk to 100% transparency with ERP traceability
Factories that operate to international standards (such as GMP, HACCP, and ISO 22000) don’t take chances with paper records. They use ERP (Enterprise Resource Planning) software to control the full product life cycle, from the receiving dock to the shipping dock, with three ironclad mechanisms:
1. Enforced FEFO (first expired, first out) picking
The ERP goes a step beyond FIFO (first in, first out) by working primarily from the expiry date. When production raises a material requisition, the ERP checks the database and directs staff to the exact location and lot number of the material that will expire soonest. If someone scans the barcode of the wrong lot, the system raises an alert and immediately blocks the stock transaction! This shuts the door on losses from expired stock completely.
2. Stopping bad material at the line (quality hold and block)
If material in the warehouse has actually expired, the ERP automatically changes its status to “Hold” (suspended from use). Even if someone takes it to the machine by mistake, the moment they scan the barcode to prepare the mix, the system will not let the work order proceed. This makes it impossible for degraded material to end up in products for your customers.
3. 360-degree traceability in a split second (end-to-end traceability)
This is the feature that saves management’s skin! If a customer raises a claim against finished-goods lot #FG999, you simply enter that number into the ERP and it instantly displays the full genealogy tree back to the source: the production date, which machine, which operator ran it, and which material lots were used, linked right through to the supplier’s purchase order (PO), all within a second. You can contain the damage and claim compensation from the original supplier with solid evidence.
Summary: control your lot codes, and you control your business’s future
Traceability isn’t just about keeping documents in order to pass an audit; it is a shield for your brand’s reputation and a way to claw profit back from the scrap pile. Investing in ERP for lot/batch and expiry management turns a warehouse you can’t see into a transparent flow of data, protecting every baht you have from going to waste on “expired” stock.
Pick any finished product in your factory at random… how many minutes, or how many days, would it take you to find out which bags of material it was made from? Plug the leaks in your raw material warehouse and build world-class traceability. Talk to our manufacturing ERP implementation experts today!
References
- Bowersox, D. J., Closs, D. J., & Cooper, M. B. (2012). Supply Chain Logistics Management. McGraw-Hill. (Cited for inventory management principles and first-expired, first-out (FEFO) stock rotation to reduce obsolescence costs.)
- Besterfield, D. H. (2012). Quality Control (8th ed.). Pearson. (Cited for quality control theory, international standards for product traceability, and effective handling of complaints through recall management.)