WMS Inventory Reconciliation by Warehouse dashboard

Warehouse Managers can use this dashboard to view inventory metrics from M3 and WMS. It helps ensure that stock levels match across both systems, preventing discrepancies that may cause operational issues.

This dashboard can answer these business questions:
  • What is the % of matched On hand balance per warehouse?
  • What is the % of not matched On hand balance per warehouse?
  • What is the % of matched and not matched Inventory?
  • Which warehouses have biggest mismatches?

Reports and KPIs

The dashboard contains the Inventory Reconciliation Details report.
  • WMS Allocated Quantity (Qty)
This dashboard also contains these KPIs:
  • Matched OHB Pct
  • Not Matched OHB Pct
  • Matched Inventory Pct
  • Not Matched Inventory Pct

The values in the KPIs are based on the selected warehouse in the Warehouse filter.

These KPIs use Load Date as the basis for analysis and the Sum aggregation.

Filters

These standard filters are available:
  • Warehouse
  • Matched OHB
  • Matched Inventory
  • Item

Warehouse and Matched OHB are required filters.