Skip to main content

Lot and batch tracking explained

How a lot number follows your stock from the day it arrives to the day it ships, and where you can see it along the way.

Your honey arrives in batches from the apiary, and every jar carries a lot number and a best-before date. Lot tracking records that number with the stock, so months later you can still say which jars came from which batch, where they are now, and who bought them.

​

What gets recorded

An item that tracks lots asks for its details every time stock comes in. The usual fields are:

​

Field

What it holds

Lot #

The number printed on the batch, for example CH-2611

Batch

A manufacturing batch number, if you use one as well

Expiration Date

A best-before or use-by date, picked from a calendar

​

You choose which fields each item uses. See Turn on lot, serial or expiry tracking for an item and Tracking field types.

​

A lot number doesn't have to be unique. Two different items can share one, and the same lot can come in more than once.

​

How a lot comes in

On a purchase order receipt. After you type the quantity and bin, click Add tracking on the line. Type the Lot #, pick the Expiration Date, and click Save tracking, then click Receive. See Receive items with a lot or batch number.

​

The Add tracking window on a receipt, with a lot number and an expiry date

​

On an adjustment. When you add stock to a lot item, you type the lot number and expiry date for the new stock. See Add or remove stock with an adjustment.

​

On a move or a transfer. The lot number goes with the stock to the new bin or warehouse. You don't type it again.

​

Where you see your lots

The item's Inventory tab. One row for each bin and lot, with the Lot #, Expiration Date, On Hand and Available.

​

The Batch / Expiry Report. In the top menu, click Reports, then under Inventory Reports click Batch / Expiry Report. It lists each lot with its warehouse, bin, quantity and expiry date. It opens on the lots that still have stock in the warehouse selected at the top right. Use the Warehouse and Tracking Status filters to see more. Click a lot number to see that row's history: the receipt it arrived on, the shipments it left on and the customer each one went to.

​

Lot GM-2611 on two rows of the Batch / Expiry Report

​

The adjustment screen. A lot item shows one row per lot, so you can add to or remove from a particular lot.

​

A lot item on the adjustment screen, one row per lot

​

Which lot gets shipped

When you create a shipment on a sales order, the item lists each lot it can pick from, with its bin, Lot #, Expiration Date and Available quantity. Click Expand all to see the lots.

​

The Pick mode note at the top of the screen explains your choice: type a quantity in Pick qty on the lots you want, or leave it blank and the lots are picked automatically, first in, first out, when you click Commit.

​

If you need a particular lot to go first, for example the one with the earliest expiry date, type the quantity on that lot's row yourself.

​

A new shipment listing two lots of the same item

​

Only lots in a pickable bin are listed. Stock sitting in a bin that isn't set up for picking doesn't appear here.

​

The same lot on more than one row

A lot can show as several rows: one for each place it sits, plus a row for every place it has been moved or transferred from. Each row has its own history, so to see the whole story of a lot, set Tracking Status to Available and Unavailable and open every row.

​

Related articles

Did this answer your question?