FMS

[Former Member]

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

[former_member1269712 · Accepted solution]

Hi Joseph,

Set below query in FMS and tick auto refresh with "When Exiting Altered Column" and select field Quantity and select "Refresh Regularly" and try...

SELECT $[RDR1.U_Quote]

Thanks

Sachin

[Former Member]

Closed earlier.. Thanks.