Skip to Content
Nov 16, 2020 at 02:35 PM

Help with a Macro

70 Views Last edit Jun 22, 2021 at 10:34 AM 2 rev


I am a novice with Macro so would like some help if possible

I am trying to use B1 Validation with a UDF Macro to work to bring a field from item master data into the sales order table. I have created the UDF in marketing document lines named

Item Syntax $[$38.U_Product_Comment.0]

Item UID 38

This is the field in item master data

Item Syntax $[$BOYX_57.0.0]

Item Table Syntax $[OITM.U_SO_Line_Comment]

This is the B1 Validation Configuration I have set

The UDF Macro line is:

Set($[$38.U_Product_Comment.0]|SQL:SELECT U_SO_Line_Comment from OITM where ItemCode = $[$38.1.0];

But it's not bringing the field info into the sales order (it's not throwing any errors either)

Can anyone advise what I am doing wrong?




hrvdd.png (78.1 kB)