FMS Query

[former_member196081]

Hi All,

I am using following query for FMS but it is not working.

SELECT (T0.[U_OD]-T0.[U_WT])T0.[U_OD].0246615* T1.[U_QTY_M] /1000 FROM OITM T0 INNER JOIN RDR1 T1 ON T0.ItemCode = T1.ItemCode where t0.itemcode = $[$38.1.0]

all sugestion will be appriciate.

Regards

Deepak

[former_member204969 · Accepted solution]

Try this one:

SELECT (T0.U_OD-T0.U_WT)*T0.U_OD*.0246615* $[RDR1.U_QTY_M.number]/1000
 FROM OITM T0
 where t0.itemcode = $[$38.1.0]

(And sending your code use the Click to display text as code icon to make it readable.)

[Former Member]

Hi Deepak,

Can you explain the functionality of the query you are writing so that a proper FMS can be suggested. As per your query, after the T0.U_OD.0246615, T1.U_QTY_M comes where there is no linkage between these two fields.

Is the query written the same way in the DB also?

Regards,

Bharath S