Hi All,
Can anyone tell how can I get the stock value in system currency using the following query.
SELECT T0.ItemCode, T0.ItemName, T1.ItmsGrpNam, T2.OnHand 'In Stock',
T2.OnHand*T0.LastPurPrc ' Stock Value' FROM OITM T0 INNER JOIN OITB T1 ON T0.ItmsGrpCod =
T1.ItmsGrpCod INNER JOIN OITW T2 ON T0.ItemCode = T2.ItemCode WHERE T2.WhsCode =[%0] and
T2.Onhand > 0 and T0.Canceled='N' and T0.InvntItem = 'Y'
Regards,
Shahid