Check Status on Sales Order Form Load

Respondida

Devin Frey

• 21 de abril de 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

• Comentario oficial

  

  Naama Aharoni

  • 27 de abril de 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

  • 6 de mayo de 2016 13:49

  Naama,

   

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

Iniciar sesión para dejar un comentario.