Summary:
The report explains changes in inventory balances in the Inventory Levels Report – RS & DTC for any selected dates. It covers inbound, outbound, and adjustment transactions.
How To Use The Report
The report provides transactions in each facility between the selected dates for all your products in the network:
| Column Name | Description |
| Date | Transaction Date and time in UTC |
| 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 |
| Category |
Following categories are included
|
| Inventory State |
Following states are included:
|
| Delta | Change in Quantity |
| OrderID | Applicable for all shipments - DTC, B2B, Removals |
| Shipment ID | Applicable for all shipments - DTC, B2B, Removals |
| ASN ID | Applicable for all inbounds - Direct, Crossdock and Internal Transfers |
| Shipping Plan | Applicable for all inbounds - Direct, Crossdock and Internal Transfers |
FAQs
Do all negative transactions lead to an adjustment?
No - please use the Inventory State and Category to determine whether inventory is moving from an available to an unavailable state, or if it is actually being adjusted out. The following categories are not considered adjustments:
- Shipment
- Receipt
- Receipt_correction
- Shipment_correction
- Transfer_In
- Transfer_Out
- Change_Attributes
- Return
- Disposed
Why do differences in some transaction categories add up to zero?
The report includes inventory state change transactions that simply move units from one state to another. These do not indicate that inventory has been adjusted out of the network.
Why do certain Receipt_corrections do not have ASNID?
For each receipt correction transaction after putaway, we do our best to link an ASNID. If you see a missing ASNID or have questions, please reach out to Customer Support.
What are Transfer_In and Transfer_Out transactions?
These reflect transfers between RS and ECOMM facilities after the initial receipt.
- Transfer_Out = units shipped out of the source facility
- Transfer_In = units received at the destination facility.
Can I raise Shrinkage claims against all Adjustment transactions?
No. While not ideal, it’s normal for warehouses to occasionally lose and later recover inventory. We work to recover lost units within two (2) months. Please reach out to Customer Support to understand your current Shrinkage before raising any claims.
Please reach out to Customer Support if you would like to request access or have any further questions.