on 01-12-2015 3:12 PM
I want to send an email when there is an approval procedure in SAP Business One. The approvals only use the internal mail. I know that the alerts can be set to send an email to the users email address. Is there a way to create a query that I can use in the alert to trigger the alert to run when the approval triggers
Any thoughts
Dennis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try this alert query for PO:
SELECT t0.docnum,T0.docdate, T3.[U_NAME] FROM OPOR T0 inner join OWDD T1 on t0.docentry = t1.docentry inner join WDD1 T2 on T1.[WddCode] = T2.[WddCode] INNER JOIN OUSR T3 ON T2.UserID = T3.USERID WHERE T2.[Status] = 'y' and T1.[ObjType] = 22 and datediff(dd, T0.docdate,getdate()) = 0
Thanks & Regards,
Nagarajan
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.