Alert Management

[Former Member]

I want to set alert management,When we create purchase document at least minmum quantity should be in 100 .

[Former Member · Accepted solution]

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.

Thanks,

Gordon

[jitin_chawla]

Hi,

You can check the following thread for similar issue. Check if you get ideas from the same :

Regards,

Jitin

[former_member187989]

Use SP Transaction notification for minimum qty in 100.

Jeyakanthan