Inventory alerts

Stock position is only ever opened when something is already wrong, so the reorder report is rebuilt from scratch every time a line runs short. This workflow reads on-hand, on-order and in-transit quantities each morning and projects them against demand and real supplier lead time rather than the planned figure. Any line landing below its reorder point before the next inbound delivery raises an alert to the named buyer with the projected shortfall, the date it bites and the quantity that would cover it. Lines moving the other way, where cover is building past a set ceiling, raise the same alert under a different reason so slow-moving stock cannot quietly tie up cash. Anything the projection cannot explain, such as a new item with no history, goes to a review list instead of an alert. What a human still decides is the reorder point itself, the safety stock behind it, and whether a projected shortfall is worth buying now or absorbing in demand.