How do I use the Lot Movement report?
Last updated: September 25, 2026
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.