Your supplier calls: lot GM-2611 of the wildflower honey has to come back. Where is the rest, who got some, and how do you stop more going out?
Find every row for the lot
In the top menu, click Reports. Under Inventory Reports, click Batch / Expiry Report.
Click the Warehouse filter, tick every warehouse, and click Apply.
Click the Tracking Status filter, tick Available and Unavailable, and click Apply.
Click + Add filter, then Lot #. Type the lot number and click Apply.
The filter finds every lot number that contains what you type, so GM-2611 would also find GM-26110. Check the Lot # column on each row and ignore any that aren't your lot.
Where is it now?
Each row is one place the lot sits, by Warehouse and Location (bin). Available Qty is what's still there and free. Stock already committed to a shipment may not be included, so also check the item's open shipments. See See which orders are holding your stock.
Who got it?
Click the lot number on a row. A window shows that row's history: the Reference (for example SO4993 - SHP12494, a sales order and its shipment), the Type, the Qty, and the Vendor or Customer. A shipment's Date is when the stock was committed to it.
Click Export to download that row's history.
Open every row, including the Unavailable ones. When part of a lot is moved or transferred, it starts a new row, and its later history is on that new row.
This shows the lot's receipts, adjustments, moves and sales shipments. If the lot was used to make other products, contact support.
Stop it going out
Set it aside while you wait for instructions. Move the lot into a bin that isn't set up for picking. See Move stock to another bin. Check the bin first: not every account has one, and a bin called Receiving may still be pickable. To check, go to Settings, Warehouses & Locations, Areas & bins and click the bin to see whether Pickable is on.
A new shipment then doesn't offer stock from that bin, and if what's left doesn't cover the order the line shows Short.
Moving the lot doesn't take it out of your numbers. It still counts in the item's Available and Can Pick, so new sales orders can still be taken against it. Watch new orders for the item until the recall is settled. If the stock must not go out under any circumstances, write it off instead.
Write it off with an adjustment, on that lot's row. See Add or remove stock with an adjustment.
How to know it worked
Run the report again with the same filters. A moved lot appears as a new row in the new bin, and the old row drops to 0. A written-off lot shows Available Qty 0 and the removal in its history.


