Check Status on Sales Order Form Load

Answered

Devin Frey

• April 21, 2016 20:48

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?

Vote

0

• Official comment

  

  Naama Aharoni

  • April 27, 2016 12:55

  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
• 

  Devin Frey

  • May 06, 2016 13:49

  Naama,

   

  Thanks for the link! That was extremely helpful in understanding the dynamic syntax.

Please sign in to leave a comment.