Lot Expiration Date
Lot expiration date is the date on which a specific lot or batch is no longer considered usable for fulfillment, quality release, or planning because its shelf life has ended or its stability/validity window has closed. It is typically calculated as origination date plus shelf-life days and drives FEFO picking and supply availability.
On the shop floor, the lot expiration date operates as a time-bound control from the moment material lands on the dock. When receiving a drum or pallet, the system calculates the date from receipt, manufacture, or origination date using shelf-life rules in the item master, then sets material status accordingly. In the warehouse, this date drives FEFO slotting, blocks expired lots from picking, and can automatically quarantine short-dated material. On the production line, operators cannot issue expired components to work orders, preventing unstable material from entering the process. For planners, MRP excludes expired lots from available supply, so shortages appear only when stock is truly unusable. Quality teams also use the lot-expiration record to narrow recall scope and confirm whether a batch is still within its valid window before release. Thus expiration date links physical inventory to system-driven planning decisions.
- Hidden stockout risk: On-hand inventory appears healthy, but expired lots are excluded from planning supply, so shortages only surface at issue time and disrupt production.
- Incorrect date capture: Mistyped receipt or manufacture dates shift the calculated expiration date, forcing good material into quarantine too early or letting unstable material remain available for release.
- Location-based FEFO failure: Workers picking by bin rather than expiration date consume newer lots first, letting older material age out and increasing scrap and customer complaints.
Is lot expiration date the same as lot number?
No. The lot number identifies the specific batch, while the expiration date defines when that batch is no longer valid for use. The lot number links each receipt to a batch for traceability, but the expiration date is the time-bound validity boundary.
Can an expired lot remain in on-hand inventory?
Yes. Expired lots are still included in physical on-hand quantities and may be transacted, but they are excluded from available supply for planning and cannot be reserved beyond the expiration date unless an operator overrides the status.
How is the expiration date typically calculated in an ERP system?
Commonly as origination date plus shelf-life days defined in the item master. Some systems allow overrides or alternate rules based on process completion, receipt date, or input material expiration.