Cordial Saludo:
Comparto informe de stock por almacén.
SELECT T2.[WhsName], T3.[ItmsGrpNam],T0.[ItemCode], T0.[ItemName], T0.[InvntryUom], T1.[OnHand] FROM OITM T0 INNER JOIN OITW T1 ON T0.ItemCode = T1.ItemCode INNER JOIN OWHS T2 ON T1.WhsCode = T2.WhsCode INNER JOIN OITB T3 ON T0.ItmsGrpCod = T3.ItmsGrpCod WHERE
T2.[WhsName] between [%0] and [%1] and T1.[OnHand] > 0 ORDER BY T3.[ItmsGrpNam] asc
A espera de sus comentarios y sugerencias.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 |