How to Track Inventory by Lot Number

To track inventory by lot number, keep the lot code connected to the item, quantity, location, status, and activity that belong to that received group. Update the lot record whenever the physical inventory changes.

1. Define the item

Create the item before receiving its lots. The item represents what the inventory is; a lot represents one received group. Review both identifiers instead of treating the lot number as a complete record by itself.

2. Define active storage locations

Create locations the team actually uses, such as a room, shelf, cooler, or bin. Names should be understandable to the people who receive and retrieve inventory.

3. Receive the lot

Choose the item and location, then enter the lot code, quantity, unit, and optional expiration date. Check the physical label before saving. If a correction is needed later, record it with a reason.

4. Record movement and consumption

When a lot moves, record its destination. When inventory is used, record the consumed quantity. The current record answers where the lot is now and how much remains, while history explains what happened.

5. Review status, expiration, and history

Use status for inventory that needs attention, review lots with expiration dates, and open lot history for the sequence of receipts, movements, consumption, status changes, and corrections.