B1P&D / B1UP, Triggering Functions from Stored ProceduresAnswered
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?
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,
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.
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
Please sign in to leave a comment.