物料成本为0的库存清单

五六零网校小于 1 分钟

示例代码

SELECT T1.[ItemCode], T1.[ItemName], T0.[WhsCode], T0.[OnHand], T0.[AvgPrice]
FROM OITW T0
	INNER JOIN OITM T1 ON T0.[ItemCode] = T1.[ItemCode]
WHERE T0.[AvgPrice] = '0'
	AND T0.[WhsCode] NOT IN ('报废仓', '退货仓')
	AND T0.[OnHand] > 0
ORDER BY T0.[ItemCode], T0.[WhsCode]