friends. could you give the alert query for particular item group. in the raw material group we are maintaining minimum stock .
grease is raw material ----- minimum stock 4500 for all ware house not separate warehouse
in stock committed ordered available
3000 2000 3300 4300
in-stock qty < minimum stock ( 3000< 4500) alert will be need is it possible???