Skip to Content
avatar image
Former Member

Alert for create new customer/vendors in BP master data screen

Hi All Experts

Is there possible to trigger alert when a new customer/vendors has created?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 09, 2016 at 08:03 AM

    Hi Kimberly,

    As far as I know, you cannot do this in a way that the alert is sent at the very moment a new BP is created, but you could set up an alert to run every 5 minutes, with the following query:

    SELECT T0.[CardCode]
         , T0.[CardName]
         , T1.[GroupName]
         , T2.[SlpName] 
    FROM OCRD T0
         INNER JOIN OCRG T1 ON T0.GroupCode = T1.GroupCode 
         INNER JOIN OSLP T2 ON T0.SlpCode = T2.SlpCode 
    WHERE T0.[CreateDate] >= DATEADD(MINUTE, -5, GETDATE())

    You can adapt the query to show more or less information, as per your requirements.

    This solution would give you a 5 minute window. Obviously you could set this to an even smaller number of minutes, but then you should also adapt the query, to prevent the alert from being triggered multiple times for the same BP.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 09, 2016 at 08:10 AM

    Hi,

    Yes possible to get an alert for new BP creation. But minimum time to receive an alert is 5 min.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 09, 2016 at 08:08 AM

    Hi,

    Frame a user defined query on OCRD table on the field createdate for current date and save it.

    Under alert management option activate this alert and set the frequency of notification in the desired user account.

    since my SAP server is down due to some technical issues, I can't tell you the exact fields and help you with screen shots.

    you can use following to create an alert

    https://blogs.sap.com/2016/09/09/alert-management-in-sap-b1/

    Hope I am able to help you.

    Regards

    Pradnya

    Add comment
    10|10000 characters needed characters exceeded