on 04-02-2011 4:17 AM
Cordial Saludo
de que manera puedo obtener un listado que me informe el stock del producto por el numero de lote que tengo en las diferentes bodegas
he buscado y no he encontrado en los informes standar
les agradeceria que me giaran por favor
ok
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
no funciono
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hola,
Desde informe operaciones número de lote, en la pestaña, almacén y desmarcas visualizar lotes con cantidad cero.
Esto lo puedes exportar a excel para visualizarlo mejor.
Un saludo.
Edited by: Aurelio Rubio on Apr 2, 2011 12:35 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HOLA
Estimado, prueba este query
SELECT T0.ItemCode, T1.ItemName, T0.BatchNum, T0.WhsCode, T2.WhsName, ISNULL((SELECT SUM(Y.Quantity) FROM IBT1 Y WHERE Y.ItemCode = T0.ItemCode AND Y.WhsCode = T0.WhsCode AND Y.BatchNum = T0.BatchNum AND Y.Direction != '1' AND Y.DocDate BETWEEN '[%0]' AND '[%1]'),0)-ISNULL((SELECT SUM(Y.Quantity) FROM IBT1 Y WHERE Y.ItemCode = T0.ItemCode AND Y.WhsCode = T0.WhsCode AND Y.BatchNum = T0.BatchNum AND Y.Direction = '1' AND Y.DocDate BETWEEN '[%0]' AND '[%1]'),0) 'Stock'
FROM IBT1 T0
INNER JOIN OITM T1 ON T1.ItemCode = T0.ItemCode
INNER JOIN OWHS T2 ON T2.WhsCode = T0.WhsCode
Saludos
User | Count |
---|---|
100 | |
11 | |
10 | |
6 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.