Skip to Content
0
Former Member
Sep 09, 2010 at 07:26 AM

FMS

12 Views

Hi All,

There is a udf created on row level of sales order which gets certain detail from quotation. I want to capture the same details of this udf on another.. I have made the following query but it doesn't help:

SELECT $[RDR1.U_Quote] FROM RDR1 T0 where T0.[ItemCode]  =  (select $[rdr1.ItemCode])

This works if there is one lineitem, but how to trigger this for multiple line items??

Thanks,

Joseph