How To View Lot Code History Via Inventory Activity
Trace a lot: see when it was received, which bins it moved through, and where it was picked or shipped, using the Inventory Activity report.Updated Nov 9 2026
Before you start
- Inventory Activity is under Parts > Reports. The Reports menu is shown to users with the Manager role (or Admin). Without it, open the report from the part instead (step 1 of Trace a lot).
- Have the lot code to hand, for example from the receipt, the label or the part's bin.
-
Trace a lot
- Go to Parts > Reports > Inventory Activity. (Or open the part and click ACTIVITY > History in its left-hand menu; the report opens filtered to that part.)
- The report opens on the last month only (chip Date is greater than …). If the lot is older, click the chip's ×.
- Click the filter search bar (Filter or search…), pick Lot Code, type the lot code, and click Apply (1). Lot codes that start with what you type are shown, although the chip reads Lot Code is ….
- Read down the rows: Reason says what happened (for example Receipt, Put Away, Shipment), Bin and New Bin Qty where the stock is, Receipt which receipt the stock came from, and User and Updated At who did it and when. A bin move shows as Put Away, with Reason Text such as Bin Move From A-05-05 To A-05-06.
- To narrow the trace, add more filters the same way: Prcpart for one part, Date for a date range, or User for the person who received or moved the stock.
-
See which lot codes were received
- On Parts > Reports > Inventory Activity, click the filter search bar, pick Reason, tick Receipt, and click Apply (1). Add a Prcpart filter to see one part (pick it from the suggestions). Remove the Date chip to see receipts older than a month.
- The Lot Code column shows the lot code entered on each receipt. If the column is hidden, click the columns icon at the right-hand end of the column headings and turn Lot Code on.
- The newest receipts are at the top (the list is sorted by Updated At, newest first), unless you sorted the report another way before: your sort is remembered. To change the order, click the Updated At heading and pick Sort A → Z or Sort Z → A (newest first).