Skip to Content
0
Dec 04, 2008 at 09:44 AM

Stock Value

98 Views

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