on 02-01-2016 2:11 PM
Buenos dias a ver si me echan una mano con este tema, tengo la consulta de las ventas.
SELECT T0.[ItemCode], T0.[Dscription], sum(T0.[Quantity])
FROM INV1 T0 INNER JOIN OINV T1 ON T0.[DocEntry] = T1.[DocEntry]
WHERE T1.[DocDate] BETWEEN '01-01-2016' AND '31-01-2016'
GROUP BY T0.[ItemCode], T0.[Dscription]
ORDER BY T0.[ItemCode] ASC
Y las devoluciones
SELECT T2.[ItemCode], T2.[Dscription], sum(T2.[Quantity])
FROM RIN1 T2 INNER JOIN ORIN T3 ON T2.[DocEntry] = T3.[DocEntry]
WHERE T2.[DocDate] BETWEEN '01-01-2016' AND '31-01-2016'
GROUP BY T2.[ItemCode], T2.[Dscription]
ORDER BY T2.[ItemCode] ASC
Pero hasta el momento no e logrado restarlas...
Hola
prueba esta consulta:
SELECT T0.Artículo, T0.Descripción, SUM(T0.cantidad) FROM
( SELECT T0.[ItemCode] AS Artículo, T0.[Dscription] AS Descripción, sum(T0.[Quantity]) AS Cantidad FROM INV1 T0 INNER JOIN OINV T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T1.[DocDate] BETWEEN '20120101' AND '20120131' GROUP BY T0.[ItemCode], T0.[Dscription]
union all
SELECT T2.[ItemCode] AS Artículo, T2.[Dscription] AS Descripción, (-1)* sum(T2.[Quantity]) AS Cantidad FROM RIN1 T2 INNER JOIN ORIN T3 ON T2.[DocEntry] = T3.[DocEntry] WHERE T2.[DocDate] BETWEEN '20120101' AND '20120131' GROUP BY T2.[ItemCode], T2.[Dscription] )
T0
GROUP BY T0.Artículo, T0.Descripción order by T0.Artículo
Un saludo
Agustín Marcos Cividanes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
9 | |
9 | |
5 | |
4 | |
3 | |
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.