on 11-11-2011 8:20 PM
Hola, saludos a todos. Molestándolos si alguién tendrá una consulta de existencias de almacén con lotes. Gracias de antemano y Felicidades, hay muchas cosas interesantes que aprender.
Hola Alberto, prueba este.
SELECT T2.WhsCode as 'Almacen', T2.ItemCode as 'Num.Articulo', T0.ItemName, T2.BatchNum,T2.Indate,T2.Quantity,T0.LstEvlPric as 'U.Pcio.Determinado',
T2.Quantity*T0.LstEvlPric as ' Valor Total $'
FROM OITM T0 INNER JOIN OIBT T2 ON T0.ItemCode = T2.ItemCode
WHERE T2.WhsCode =[%0] AND T2.Quantity < > 0 order by T2.WhsCode,T2.Itemcode,T0.Itemname,T2.batchnum,t2.indate,t2.quantity,t0.lstevlpric
T2.Quantity mayor a cero
Saludos
Alessandro.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.