Hi, I am using Formatted search feature in a Goods Receipt PO document to resolve a UDF value from OITM when an ItemCode is entered into the Item No field. This works fine and automatically resolves. Please see query below:-
SELECT T0.[U_BinLocn] FROM OITM T0 WHERE T0.[ItemCode] =$[$38.1.0]
I have tried to do the same for Goods Receipt and created the following query:-
SELECT T0.[U_BinLocn] FROM OITM T0 WHERE T0.[ItemCode] =$[$13.1.0]
However, this UDF value is only resolved when the user selects the magnifying glass on the document. It does not automatically update even though the "User-Defined Values - Setup" values are configured identical.
Can anyone advise?