In this Article:
- Overview of the "Inventory Levels Report - RS & DTC" Report
- How to use the Report
- Report FAQs
Overview
We have made the following improvements to the “Inventory - Levels Today" Report available on Seller Portal:
- This report provides total units physically present in the facilities and:
-
- Includes any pending orders
- Includes inventory unavailable for sale, ie., unavailable states (expired, damaged etc.) and Ops work in progress quantity (Receiving)
- Processing Inventory in legacy report is retired and replaced with Unavailable for Sale Qty and Ops WIP Qty
- 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 balances
Please reach out to support if you would like to request access or have any further questions.
How To Use The Report
The report provides end of day balances in each facility for the selected date for all your products in the network
| Column Name | Description |
| Snapshot Date | Date with Time & time zone in UTC |
| DSKU | Identifier assigned by Flexport |
| MSKU | Your unique identifier assigned to the product on Flexport portal |
| Name | Product Name |
| Facility Location | City & state of warehouse facility |
| Facility | Flexport code for facility location & In-Transit for units transferring facilities |
| DTC Total Qty |
Balance (total inventory physically available in DTC Facilities) on snapshot date at 12:00AM UTC for fully received in the sites including unavailable & Ops WIP quantity Does not include Inbounding units |
| RS Total Qty |
Balance (total inventory physically available in RS Facilities) on snapshot date at 12:00AM UTC for fully received in the sites including unavailable & Ops WIP quantity Does not include Inbounding units |
| Unavailable for Sale Qty | Units in different quarantine states like On Hold, Damaged, Expired etc that cannot be used for selling in a warehouse |
| Ops WIP Qty | Units worked upon by warehouses e.g., receives and any units in non-pickable locations |
| Units in Pack/Boxes | Applicable for Reserve Storage Facilities. Shows Units in a pack |
| # of Packs/Boxes | Applicable for Reserve Storage Facilities. Shows total Packs/Boxes |
| In Transit Qty |
Units transferring facilities for replenishments or consolidation transfers. Includes CD-DTC, DTC-DTC, RS-RS, RS-CD-DTC, RS-DTC* facility transfers. Does not include Inbounding units |
*CD= Cross dock, DTC= Ecomm facilities, RS=Reserved Storage Facilities
FAQs
How do I arrive at total units in the network at the end of day?
Taking DTC Total Qty and/or RS Total Qty gives you end of day balances in facilities. But if there are any In Transit Qtys, include them to show total units in the network.
Why don’t the totals in legacy reports (namely AVAILABLE IN ECOM and AVAILABLE IN RESERVE in Inventory - Levels Today Report) available on the portal match with this report?
Totals in legacy reports did not include pending orders, units in unavailable states or Ops work in progress quantity. So, the totals in new reports will vary.
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.