Skip to main content

Lot Numbers

Inventory → Lot Numbers (/inventory/lots) lists the batches (lots) of your lot-tracked items. A lot is a group of units made or delivered together that share a batch number and often an expiry date — a drum of oil, a carton of filters from one production run.

Lot tracking lets you answer questions like "which batch did this come from?" and "what expires next month?", and lets the system send the earliest-expiring stock out first.

It only applies to items whose Tracking Type is Lot / Batch in the Item Catalog.

How lots are kept up to date​

You rarely need to touch this page. Lots update themselves as stock moves:

  • A Stock IN of a lot-tracked item with a Lot No. (on the New Stock Transaction form or the Scan Station) creates the lot, or adds to it if it already exists.
  • A Stock OUT reduces the lot's remaining quantity, and is refused if the lot does not have enough.
  • The opening stock import needs a Lot No. (and can take an Expiry Date) for every lot-tracked row.
  • When a delivery picks stock of a lot-tracked item, it proposes the bin of the earliest-expiring lot.

When to use this page​

  • Checking how much of a batch is left and where it is.
  • Finding stock that is about to expire.
  • Tracing a batch during a supplier recall.
  • Recording a lot in advance.

Before you begin​

inventory.serials.view opens the page (lots share the serial permissions); inventory.serials.manage adds Register Lot. The Warehouse Manager role has both.

Understanding the page​

Standard list layout (Working with lists).

ColumnMeaning
Lot No.The batch number, in upper case.
SKU, ItemWhich item.
RemainingHow many of this lot are left. Qty Received (hidden by default) is how many came in.
ExpiryThe expiry or best-before date, if any. Sort by it to see what expires first.
WarehouseWhere the lot is. Bin is hidden by default.
CreatedWhen the lot was first recorded.

Register a lot​

  1. Select Register Lot.
  2. Choose the Item, enter the Lot No. (required, unique for that item), the Qty Received (more than 0), and optionally the Expiry Date, Location (Bin) and Notes.
  3. Select Register. You see "Lot registered".
Registering a lot does not add stock

This creates the lot record only. The bin's quantity changes when stock is actually moved with the lot number. In most cases it is simpler to let a Stock IN create the lot for you.

Purchase receipts do not ask for lot numbers. When a lot-tracked item arrives on a receipt, register its lot here (with the quantity and expiry) so the batch can be traced and picked by expiry.

Find what is about to expire​

Sort the Expiry column ascending, or filter it to a date range from the column menu. For a regular reminder, set up an inventory alert with the condition Lots expiring soon.

Common issues​

ProblemWhat to check
"Lot '…' already registered for this item"Lot numbers are unique per item; the lot exists.
A Stock OUT fails with "Lot '…' has insufficient quantity"The lot has less remaining than you are issuing. Split across lots.
"lotNo is required for Lot-tracked item …"Every movement of a lot-tracked item needs a lot number.