Lot traceability worksheet
Follow a lot from receipt to location and customer allocation.
Download worksheet (CSV)Capture the origin
Record supplier, purchase order, receipt, lot or serial reference, unit and quantity. Keep the original supplier documentation with the receipt.
Follow the movement
Record site, bin, handling unit, movement time and person completing each custody change.
Identify affected commitments
List every reservation and fulfilled order linked to the lot. Keep held stock separate from stock eligible for allocation.
Reconcile the balance
Compare received quantity with current stock and outbound allocations. In the example, 60 received equals 24 reserved plus 36 remaining on hold.
Examples use synthetic records and illustrative quantities or rates.
Explore all resources →