FMS is not wokring quantity * U_KG SAP B1

[nikunjmehta2290]

Dear all,

SELECT T1.Quantity * T1.U_KG
FROM RDR1 T1
WHERE T1.ItemCode = $[$1.ItemCode]

OR

SELECT T1.Quantity * T1.U_KG from RDR1 T1 where T1.ItemCode = $[$38.1.0]

This both FMS is not working, SAP B1, SAP Business One

Regards,

Nikunj

[SonTran]

Hi,

Try this

Select $[$38.11.number] * $[$38.U_KG.number]

Hope this helps,

SonTran

[PaulB1ID]

Hi @nikunjmehta2290 ,

Try this

SELECT $[RDR1.Quantity]*$[RDR1.U_KG]

Regards,

Paul