Skip to Content
avatar image
Former Member

Link an Approval Procedure to an Alert in B1

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


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 12, 2015 at 03:32 PM


    You can check the link bellow:

    With Regards,

    Harris K.

    Add comment
    10|10000 characters needed characters exceeded

    • 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,