cancel
Showing results for 
Search instead for 
Did you mean: 

Link an Approval Procedure to an Alert in B1

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hello,

You can check the link bellow:

With Regards,

Harris K.

Former Member
0 Kudos

thanks,

I read the link, but did not help. I need to see if anyone has written a query in SAP that I can use in the alert.

kothandaraman_nagarajan
Active Contributor
0 Kudos

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