on 12-08-2008 9:03 AM
In my Inventory Repoprts--Inventory in warehouse report, it lists all items stock but no item price there. all items' item price are empty. I can't get the inventory total cost. what can i do? how come does it happen?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
To have item price in the warehouse report, you have to select detail reprot & need to select last evaluated price.
Regards,
Abhishek
You try this Query, it will show the average cost per Item per whse.
SELECT T0.WhsCode, T0.ItemCode, T1.ItemName, T0.OnHand, T0.AvgPrice, ( T0.OnHand * T0.AvgPrice) AS 'TOTAL' , T0.StockValue FROM OITW T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode WHERE T0.OnHand >0 ORDER BY T0.WhsCode, T0.ItemCode
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.