Supply Chain BI Ideas Portal

Warehouse Inventory Variance Report

Retail

At a point in time comparing sky & qty between warehouse DC inventory (SCALE/WMOS) to Merchandising System (IP)

                Data   DC#, Sku, description, variance (DC qty – Merch qty), Variance total cost, Allocated not shipped qty (C Status)

                sort descending order (sort by cost /qty 

 

Ecom – same as retail but compare warehouse FC inventory to Merchandising System eComm store number 1999

                Data   FC#, Sku, description, variance (FC qty – store qty), Variance total cost, ordered not shipped qty (C Status/demand sales)

                sort descending order (sort by cost /qty 

 

Data rules

  • exclude C status item qty in whse inv for comparison to be same as IP, but for visibility show C QTY   
  • receipt after putaway in whse inventory.
  • Kraig Meyer
  • Sep 19 2018
  • Planned
  • Attach files