Overview
The Lot Movement report shows every inventory transaction that touched a lot-tracked product within a date range. Use it to audit lot history, trace where inventory went, verify expiry-driven deductions, or investigate unexpected balance changes.
This report is available under Insights → Lot Movement. It must be enabled for your tenant — if you don't see it in the navigation, contact Luminous support.
Filters
| Filter | How it works |
|---|---|
| Date range | Required. Filters transactions by the date the movement was recorded. |
| SKU | Optional. Type to search and select a single product. |
| Warehouse | Optional. Multi-select; limits results to one or more warehouses. |
| Lot # | Optional. Enter a lot number to see only movements for that lot. |
Filters are saved between sessions so your last view is restored when you return.
Columns
Supplier, Invoice, Finished Product and FG Qty are hidden by default — enable them from the Columns panel on the right edge of the grid. Use Reset columns to restore the default layout.
| Column | What it shows |
|---|---|
| Date | Timestamp of the inventory transaction |
| Raw SKU | Internal SKU of the product that moved |
| Raw Product | Product name |
| Initial Balance | Lot quantity immediately before this transaction |
| UOM | Unit of measure |
| Transaction | Labelled as Work Order number, Assembly Order number, or PO number when applicable; falls back to the raw transaction type |
| Finished Product | SKU and name of the finished good (assembly output), when the movement came from an assembly or work order |
| FG Qty | Quantity of finished goods produced by that assembly |
| Supplier | Supplier name, when the movement originated from a purchase order receipt |
| Qty | Signed quantity: positive = received/added, negative = deducted/consumed |
| Lot # | Lot number |
| Expiration | Lot expiry date |
| Invoice | Invoice date from the originating purchase order |
| Ending Balance | Lot quantity immediately after this transaction |
Sorting
Click any underlined column header to sort. Sortable columns are: Date, Raw SKU, Transaction, Qty, Lot #, and Ending Balance. Only one sort column is active at a time.
Pagination
Results are paginated. Use the page controls at the bottom to navigate, or type a page number directly into the Page field.
Export to CSV
- Apply your desired filters and confirm rows appear.
- Click the Export button in the top-right corner.
- A CSV file downloads with all matching rows (subject to the system row limit; a note appears in the file when the result was truncated).
Common use cases
- Trace a lot recall — filter by lot number to see every movement: which PO it came in on, which assembly orders consumed it, and the ending balance.
- Verify FEFO deductions — sort by date ascending and check that the oldest lots show negative qty entries before newer lots.
- Reconcile a warehouse count — filter by warehouse and date range, then sum the Qty column to verify net movement matches your physical count delta.