Model Goods Receipt So Bad Lots Cannot Enter Production: Supplier Intake for ERP Builders
By Isaac Muthui, CEO, Tamalaki Business Network Ltd. Originally published at factoraerp.com . If you build inventory or ERP software for manufacturers, here is a failure mode worth designing out: raw material is booked into free stock before anyone has finished receiving checks , so production can consume a lot that should have been held or rejected at the gate. In small food and agro factories…
In small food and agro factories in Kenya, where the author works, raw material is often accidentally booked into free stock before receiving checks are completed. This allows production to consume items that should have been held or rejected at the gate. The weak point is that accept, hold, and reject statuses are often recorded manually on a clipboard or in a chat, while the quantity row in the system already appears available.
To address this issue, the author suggests modeling goods receipt, lot status, and quarantine within the system to enforce the gate. Receipt lines should carry lot identity, including supplier lot code, manufacture/expiry dates, and a link to PO line. Each lot should have a receiving/quality assurance (QA) status with options such as PENDING_RECEIPT, ACCEPTED, ON_HOLD, QUARANTINED, and REJECTED.
Pending is the default status at goods receipt (GRN). When the truck is booked in, the status is set to ACCEPTED only after the intake checks are complete. Available-for-production should exclude non-accepted lots, ensuring that production issues, backflush, and reservation queries only see ACCEPTED (or a similar released-for-use status) lots.
Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.
