Check Status on Sales Order Form Load Answered
Hey All,
I'm working with the B1 Validation Configuration to try and attempt to check the status of a sales order in an external system when it's loaded.
My intended functionality is to check if the S/O is being picked in our Warehouse Management System as soon as it's searched by our Orders department. I already have SQL to return a String or other value when it IS in that state, but I would like to trigger a popup.
Currently, I'm using FormMode: OK/Update, Event: Data Load, BeforeAction: True, and I'm just trying to execute this with a simplified SQL statement:
IF(SELECT Count(DocNum) FROM ORDR WHERE DocNum = $[$139.8.0]) = 1
BEGIN
SELECT 'Popup' FOR BROWSE
END
If I'm reading other examples correct, I'm using the right variable ($[$139.8.0] should be the Sales Order Number), is there a different FormMode I should be using?
Comments
2 comments
Hi Devin,
There is an error in your dynamic syntax, dochum should be $[$8.0.0].
For more information on how to work with dynamic syntax please look at: https://support.boyum-it.com/hc/en-us/articles/204284188-Guide-Understanding-Dynamic-Syntax
Thanks, Naama
Naama,
Thanks for the link! That was extremely helpful in understanding the dynamic syntax.
Please sign in to leave a comment.