Column ID of a UDF

[steven_delombaerde2]

Does anyone know how to reference a column id of a UDF in a formatted search?

Say you have a UDF called "netprice" on the marketing document line level. You could reference this new field as 'rdr1.u_netprice' in a formatted search on a sales order no problem. However, this implies having multiple queries for the same formatted search if you want to use it on Quotes and Deliveries, etc.

Is there any way you can reference the screen column of a udf, like in '$38.1.0', where the latter is the itemcode? I have tried with '$38.u_netprice.0' but that doesn't work. What is the correct syntax?

Is there any other ways of doing this?

PS I have omitted the dollar square brackets above because they translate into http:// on this forum

Thanks

Steven

Edited by: Steven Delombaerde on Sep 4, 2008 2:43 PM

[Former Member · Accepted solution]

Hi Steven,

Where do you get those netprice for these UDF?

It your U_netprice is on the item master, then it will be very easy. You can use something like:

where itemcode = $[$38.1.0] 

from oitm table.

Otherwise, you may have to refer to different tables by different FMS.

Thanks,

Gordon

[Former Member]

Hi Steven

Try ${$38.U_netprice.NUMBER} (I used different brackets-replace with square brackets).

Kind regards

Peter Juby