Greeting of the day..
I have created one UDF field (price) at Business Partner Master data.
and another field at delivery row level labour amount.
now i want multiplication of the master filed with delivery quantity at each row level. I have tried the below FMS.
(SELECT T0.[U_LabCost] FROM OCRD T0 INNER JOIN ODLN T1 ON T0.[CardCode] = T1.[CardCode] INNER JOIN DLN1 T2 ON T1.[DocEntry] = T2.[DocEntry] WHERE T0.[CardCode] =$[ODLN.CardCode.0]) * ($[DLN1.Quantity.0])
but couldn't get result.
Try this query SELECT $[OCRD.U_PRICE] * CAST(REPLACE($[$38.11.0],',','') as FLOAT)
as FMS in labour amount field with quantity as focus.