Alert for "On Hand" below "Minimum Inventory" in last 60 mins
How do I create an alert which will give a list of Item Codes of a particular "Item Group" only whose "On Hand" quantity has fallen below the "Minimum Inventory Level" in the past 60 minutes?
I am not sure if you read the 3 replies you have received. The system has functions out of the box to prevent / warn when this scenario occurs. Why would you want to create something custom through a query ? Is there is a reason if I may ask ???
OITM is not the table where stock information is stored. It is the OITW table. but the inventory transaction are recorded in the Warehouse Journal table (OINM)
Please look at the OINM table if you still are of the idea to do something on your own