In This Article:
- Overview of "Hourly Inventory Levels Report - RS & DTC"
- How to Use the Report
- Report FAQs
Summary
The Hourly Inventory Levels Report - RS & DTC provides an hourly snapshot with additional details compared to the "Inventory Levels Report - RS & DTC" available on the Seller Portal:
-
Ops WIP Qty Breakdown:
- Receiving Ops WIP Qty: Units pending putaway.
-
Outbound Ops WIP Qty: Units ready to ship.
-
In-Transit Quantity Breakdown:
- Provides a detailed breakdown by destination sites for RS to CD to DTC transfers.
- Provides a detailed breakdown by destination sites for RS to CD to DTC transfers.
-
Reserved Order Breakdown:
- WH Allocated Order Qty: Units/orders pending to be picked.
- Unallocated Qty: Units/orders pending to be assigned to sites.
- RS Scheduled Order Qty: Future B2B orders not allocated to sites.
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 |
| DSKU | Unique product identifier maintained by Flexport |
| MSKU | Merchant product Identifier |
| Name | Product Name |
| Facility Location | City & state of warehouse facility |
| Facility | Flexport code for facility location. Also shows In Transit, DTC unallocated & RS Scheduled orders as separately where applicable |
| DTC Total Qty | Total units physically present in DTC warehouse includes sellable, onhold, damaged, expired etc |
| RS Total Qty | Total units physically present in RS Warehouse includes sellable, onhold, damaged, expired etc |
| In Transit Qty |
Shows all units moved within Flexport network. Include DTC<>DTC, DTC <> RS, RS-CD-DTC 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 |
| WH Allocated Order Qty |
DTC: Units reserved for orders and actively being picked RS: Units reserved for order but site has not started to pick/pack etc |
| Unallocated Qty | Units reserved for orders in the network but have not been assigned to the warehouses yet |
| Receiving Ops WIP Qty | DTC/RS: Units actively worked upon by warehouses for inbounds/receiving |
| Outbound Ops WIP Qty | DTC/RS:: Units actively worked upon by warehouses for active outbound orders and in staging locations (units ready to ship) |
| Other Ops WIP Qty | DTC/RS: Units actively worked upon by warehouses for internal relocations and temporarily unavailable for sale |
| RS Scheduled Order Qty | Units reserved for future orders in the site |
| WH ATP Quantity |
Shows units available for new orders. Derived as TotalQty-Unavailable for SaleQty-Ops WIP Qty - WH Allocated Qty - Unallocated Qty |
| 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 |
FAQs
- Why do totals in the portal do not match with this report?
- Totals in seller portal UX does not include pending orders, units in unavailable states or Ops work in progress quantity.
- The new “Inventory Levels Report - RS & DTC” is end of day report, while this report is refreshed every hour
-
Why does WH ATP quantity in the report not match with Available units in Seller portal UX?
- ATP in this report is split by warehouse, subtract unallocated order quantity to arrive at network ATP
- Since the report is refreshed every hour, there will be differences for new orders received in the hour. The differences could be high for fast moving products