Ever wonder why things change? You have your inventory min/maxes set, you're using all the best practices and then Bingo, something changes. Well, we had a Juice client asking the same questions so we created this alert which will review all StockMin & StockMax changes to warehouse item records. It will also let you know whenever the effective qty (qtyonhand + ordered - allocated) exceeds the stockmax where stockmax > 0. This one alert checks all three statuses for each warehouse/item and reports what triggered the item on the report (change to max, change to min, qty > max). The standard version of this report only monitors warehouses that are either Customer or Technician type.
See below for sample output:
Alert has one variable:
Variable W (Flag to include/exclude qty > stockmax on report )