The Out of Stock with Sales report lists all products with sales for the date range selected, but are currently out of stock. Any item out of stock with sales requires a closer look to determine what action if any needs to be taken. You should periodically run this report to determine if products listed on the report need to be ordered from your supplier.

This report takes into account AFN (FBA) quantities using the (Products.QtyFBA = 0 ) field in the products table, and including only those products listed on FBA (Products.ListingFBA = True) where the order fulfillment type is AFN (OrdersDetail.FulfillType = ‘AFN’). Products will only appear on this report when those conditions are met for the date range and other filter options selected via the data filters.

The Quantity in Transit Qty IT (Products.QtyIT) or Quantity Reserved Qty Resv (Products.QtyFBAR ) is ignored since these quantities in transit and reserved are not available for sale.