FMS Query

[Former Member]

Dear All,

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.

Regard,

Datta Kharat

[Former Member · Accepted solution]

Hi,

Try this query SELECT $[OCRD.U_PRICE] * CAST(REPLACE($[$38.11.0],',','') as FLOAT)

as FMS in labour amount field with quantity as focus.

Cheers,

Shiva

[former_member211473]

hello datta ,

try

SELECT ( $[OCRD.U_PRICE] ) *( $[$38.11.number] )

price is header level udf in ocrd table

Regards

Ranu

[Former Member]

[Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the nvarchar value '.150000' to data type int. '' (SWEI)

getting dis error...

[Former Member]

what datatype have you given for 'U_PRICE'?