查询报表：批次库存报表

SELECT T0.[ItemCode], T0.itemname, t1.InvntryUom AS 单位, T0.[WhsCode], T0.[BatchNum] AS 批次
	, T0.[Quantity]
FROM OIBT T0
	LEFT JOIN OITM T1 ON T1.ITEMCODE = T0.ITEMCODE
WHERE T0.[Quantity] > 0
ORDER BY T0.[WhsCode]

五六零

海报 链接