Skip to Content

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

Thanks

Steven

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 04, 2008 at 02:21 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 02:36 PM

    Hi Steven

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

    Kind regards

    Peter Juby

    Add comment
    10|10000 characters needed characters exceeded