Skip to Content
avatar image
Former Member

SAP B1 alert trigger

Dear Experts,

We are using SAP B1 9.0 PL 15 and MS SQL 2012.

We are wondering if it is possible to trigger SAP's alerts when a document is posted.

Do you any advice?

Kind Regards,

Vasilis Korolis

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Apr 12, 2016 at 05:10 AM

    Hi Vassilis..

    Yes it is possible ,

    check with the link for more details

    https://help.sap.com/saphelp_sbo900/helpdata/en/45/06437557240484e10000000a155369/content.htm

    Hope Helpful

    Rgds

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 12, 2016 at 05:11 AM

    If you are not talking about realtime alert and allow a few minutes delay, then the answer is yes.

    You can either directly query the table and find the newly created documents.

    Or use a customized table to hold those newly created document reference, using SP_TN to add records into customized table. This method should have better performance since it always deals with much smaller data set.

    Frank

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 12, 2016 at 07:31 AM

    Hi Vassilis,

    Check B1iF - definitely can work real-time.

    Kind regards,

    Radek

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 12, 2016 at 08:01 AM

    Hi Vassilis,

    Yes it is possible. Advise which document you want to trigger alert ?

    Thanks,

    Harshal

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Vassilis,

      Select T0.[DocNum], T0.[CardName], T0.[DocDate], 'New Invoice Created' from [OINV] T0

      where T0.[DocDate] = (select left(getdate(),11))

      Assign this query in alert management.

      Hope this solve your issue.

      Let me know if you need more information.

      Thanks,

      Harshal

  • Apr 12, 2016 at 01:31 PM

    Hi,

    It is not possible to trigger alert immediately after adding invoice. Atleast system needs 3 to 5 min to trigger saved alert.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 18, 2016 at 01:33 PM

    Hi,

    Please close the thread if you got the answer.

    Thanks,

    Harshal

    Add comment
    10|10000 characters needed characters exceeded