批次库存报表
小于 1 分钟
代码示例
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]
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]