Description
This report aims to provide sellers with information on inventory movements for any selected month range. Each row will correspond to a DSKU-Month. If seller with a DSKU D1 selects Jan'21 to March'21 then there would be 3 rows (DSKU D1- Jan'21, DSKU D1- Feb'21 and DSKU D1- Mar'21)
Documentation
Column |
Description |
START_OF_MONTH_ON_HAND |
On hand qty (units) that is available for sale in Flexport's network at the start of month |
START_OF_MONTH_NONPICKABLE |
On hand qty (units) that are unavailable for sale in Flexport's network at the start of month |
START_OF_MONTH_TRANSFERQTY |
Units being transferred from one warehouse to another at the start of the month |
END_OF_MONTH_ON_HAND |
On hand qty (units) in Flexport's network at the end of month |
END_OF_MONTH_NONPICKABLE |
On hand qty (units) that are unavailable for sale in Flexport's network at the end of month |
END_OF_MONTH_TRANSFERQTY |
Units being transferred from one warehouse to another at the end of the month |
SHIPPED |
Units sold within the month |
REMOVED |
Units removed out of Flexport's network within the month (as requested by seller) |
RETURN_QTY |
Units returned within the month |
CANCELED_SHIPMENTS |
Units sold in previous month but order got canceled in current month hence these units would be added back to the inventory |
CANCELED_REMOVALS |
Units removed in previous month but removal order got canceled in current month hence these units would be added back to the inventory |
BEGINNING_TIMESTAMP |
Timestamp of start of date range in UTC |
END_TIMESTAMP |
Timestamp of end of date range in UTC |
NET_INVENTORY_ADDED |
ending_qty + shipped + removed - beginning_qty - canceled_shipments - canceled_removals - return_qty |