Column ID of a UDF
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
Edited by: Steven Delombaerde on Sep 4, 2008 2:43 PM
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.