B1P&D / B1UP, Triggering Functions from Stored Procedures

Answered

Devin Frey

• November 14, 2016 16:34

Hey Community,

We've been testing P&D and are in the process of implementing the functionality into our live system. I wanted to look into using P&D to alert users of specific events (such as an order being approved), but we don't use the main UI to accomplish that.

We have a set of Transaction Notification routines that trigger a similar affect. Is there any way to trigger P&D actions, or B1UP Universal Functions from SQL?

Vote

0

• Official comment

  

  Naama Aharoni

  • November 16, 2016 10:39

  Hi Devin,

  You can use the "Report Action" type "internal Message" to send messages to relevant users based on specific SQL.

  Then you can put it into the scheduler.

  For example, you could make a query the "Approved" field in the sales order and then set up a server component schedule that look at all those sales order which their approved value is set to = Y and send internal messages based on those. It will have a little delay but will happen no matter where the sales order was created.

  Hope it helps,

  Naama
• 

  Devin Frey

  • November 16, 2016 16:40

  Hey Naama, thanks for the response.

  I could certainly handle it on a timer, I could do that via an Alert (standard SAP) but was looking / hoping to discover an alternative.
• 

  Wendy Tranter

  • November 20, 2016 00:34

  Hi Devin

  You can also use a validation to trigger P&D.  You can use an event in B1 UP's validation such as validate a field, lost focus, etc, to put the condition in, then trigger a Macro to call for P&D's configuration.

  e.g. if you want to call for an email Action in P&D configuration 41, then your syntax can be

  B1P&D(41|EMAIL);

  Kind Rgds

  Wendy

Please sign in to leave a comment.