Trigger Alert Based on Reorder Point
A planner is planning supply and demand for a product at a warehouse location. Row 1 of the data view shows inventory levels for this product at this location. The planner wishes to know when he needs to order new inventory. The macro determines for each period whether the stock level has fallen below the reorder level for this product/location combination. If it has, an alert is triggered informing the planner that he needs to reorder.