Alert message is not coming

[Former Member]

Hii experts,

         I am new to this SAP B1  , I am facing some issue while creating alert for inventory transfer.    

My requirement is :

Draft should be created by production department in inventory transfer document , after they make as draft alert should go to the purchase department.

I wrote this query but still i didnt get it.

SELECT 'Transfer' AS 'Document Type', T0.DocNum, T0.DocDate AS 'Ship Date', T0.DocEntry

FROM dbo.OWTR T0

WHERE T0.ObjType = 67 AND DateDiff(dd,T0.DocDate, GETDATE()) = 0

Please help me to resolve this issue

Thank you.

Warms and Regards

Neelima

[former_member183750 · Accepted solution]

Please post to the SCN Space.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

SCN Moderator