Formatted Search Not updating

[former_member529677]

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?

Many thanks

Alan

[former_member233854]

If you want to resolve when something is entered in the Item No Field, shouldn`t it be $[$38.1.0]? You are using 13 in the second query.

[former_member529677]

Hi Danilo, thanks for your reply. When i first created the Formatted Search using the same query on "Goods Receipt PO" it did not work.. After a little research I discovered that $[$38.1.0] is a form system variable for the ItemNo on a "Goods Receipt PO"  for "Goods Receipt" the form system variable for the ItemNo is $[$13.1.0]

Kindest regards,

Alan

[former_member233854]

Sorry, I thought you were trying to use in the Goods Receipt PO. I have tested here with an sample query and setup to "Auto refresh" --> "When exiting altered column" --> "Item No." it worked fine, how did you setup your UDF settings?

Are you using the receipt from production, or the goods receipt under inventory transactions? because both internally are goods receipt.

[former_member529677]

Hi Danilo, i'm using Goods Receipt within Stock Transactions. I'm thinking it could be related to the form layout as after trying a few things I can get the value to automatically update when using the Item Description but not the ItemNo?

[former_member233854]

hmm well, the only thing I can think it is that it might have something "wrong" in the formatted searach settings, how did you setup the formatted search?

[former_member529677]

Hi, just the usual "Shift, Alt & F2" when selecting the Field in the form view... Then selecting the

saved query "GR-BinLocn"

A bit of a strange one...

[former_member233854]

yeah, I did the same here using the Item No instead, sorry buddy, I have no more good suggestions.

hmm is there any add-on running? have you tried in another version/database?