In this Article:
- Overview of "Inventory Detail Report - LOT & FEFO (Single product)"
- How to use the Report
- Report FAQs
Summary
We made the following improvements to the “Inventory - Lot tracking and FEFO (Single product)” report available on Seller Portal:
-
This report provides total units physically present in the facilities and,
- Includes any pending orders
- Shows inventory unavailable for sale, ie., unavailable states (expired, damaged etc.) and Ops work in progress quantity (Receiving)
- Introduced Unavailable for Sale Qty and Ops WIP Qty
- Introduced “State” a new column that provides further information about unavailable nature of the units
- Introduced “Ops WIP Quantity Flag” to provide visibility into units that are still worked upon by sites.
- Shows In Transit units for a DSKU
- Total Reserve Storage units in a facility are further split into Packs/Boxes
- Provides historical data, you can select any historical date (from 1st Sep 2025) and download the end of day report
Please reach out to support if you would like to request access or have any further questions.
How To Use The Report
The purpose of this report is to provide a detailed breakdown of the lot tracked and expiration tracked inventory. The report will only be available if at least one product in your inventory is enabled for lot tracking and/or FEFO fulfillment. If you do not have any product enabled you will receive an error upon attempting to generate this report.
| Column Name | Description |
| Snapshot Date | Date with Time & time zone in UTC |
| DSKU | Unique product identifier maintained by Flexport |
| MSKU | Merchant product Identifier |
| Product Name | Product Name |
| Facility | Flexport code for facility location. Also shows In Transit, DTC unallocated & RS Scheduled orders as separately where applicable |
| Facility Location | City & state of warehouse facility |
| Service |
Will shows balances in all sites for corresponding network:
|
| LOT Number | Lot number tied to the inventory. This number is provided by the merchant and validated (or captured) during receiving. |
| Expiration Date | Expiration date for the inventory |
| State | Inventory State - Sellable, Damaged, Expired etc. |
| LOT Status | Status of said lot, can have the following values:- fulfilling orders- quarantine requested- quarantined- removal requested- removed- disposal requested- disposed- In Transit |
| Days to Expiry | Number of days left until the inventory expires |
| Ops WIP Quantity Flag | True/False. If True, Units worked upon by warehouses e.g., receives and any units in non-pickable locations |
| Quantity | Total Units in the network |
| Units in Pack/Boxes | Applicable for Reserve Storage Facilities. Shows Units in a pack/box/case |
| # of Packs/Boxes | Applicable for Reserve Storage Facilities. Shows total Packs/Boxes/Cases |
FAQs
How do I arrive at total units in the network at the end of day?
Taking net sum of quantity for a DSKU (could be in multiple rows) provides total units in the network
Why don't the totals in legacy reports (namely Inventory - Lot tracking and FEFO (single product)) available on the portal match with this report?
Totals in legacy reports did not include pending orders, units in unavailable states, Ops work in progress quantity and In Transit. So, the totals in new reports will vary.
Why isn't there a LOT number associated with some units?
Any In Transit units will not have a LOT number and will reflect once the units are received in the facilities.
The report shows fewer total units than what I expect, how should I go about it?
Any non-compliance or inbounding units are not part of Totals. It shows units physically verified and added to the sellable/available inventory at site.
If you need more help understanding your inventory report, please contact the Support team.