I want to set alert management,When we create purchase document at least minmum quantity should be in 100 .
Gordon Du replied
You can create an alert based on user query like:
SELECT DISTINCT T1.DocNum FROM POR1 t0 INNER JOIN OPOR T1 on T1.DocEntry = T0.DocEntry WHERE T0.Quantity < 100 AND DATEDIFF(DD,T1.CREATEDATE,GETDATE()) = 0
You can select this new query by clicking on Open Saved Query button to bring up Query Manager and assign to your new alert.