SELECT T0.DocNum, T0.UserSign, T0.JrnlMemo
FROM dbo.OIGE T0
WHERE T0.JrnlMemo = 'Goods Issue'
I want to get alert when a new Goods Issue is posted.
In Alert management I have changed to add mode and given alert: name, tick active box, selected Query above from 'open saved query' and ticked 'Int.' and 'Email' box for myself. Frequency is set for every minute for testing purpose.
I add a Goods Issue but alert does not happen. Where do I go wrong?
Thanks