on 10-28-2014 6:49 PM
Necesito saber diariamente cuantas referencias tengo en solicitud de traslados por Fecha
tengo el siguiente querry
SELECT T0.[ItemCode], T0.[ItemName], T0.[OnHand], T1.[Quantity]
FROM OITM T0
INNER JOIN WTQ1 T1 ON T0.ItemCode = T1.ItemCode
INNER JOIN OWTQ T2 ON T1.DocEntry = T2.DocEntry
WHERE T0.[ItmsGrpCod] between '110' and '114' and T2.[DocDueDate] =[%0]
Pero necesito que las cantidades se sumen y que las referencias que no estan en los traslados del dia me salgan en Quantity 0.
Favor ayudarme
Saludos
ER
Yo modifique un poco la estructura.
SELECT T0.[ItemCode]
, T0.[ItemName]
, T0.[OnHand]
, sum(T1.[Quantity]) as 'Solicitud'
FROM OITM T0
LEFT JOIN WTQ1 T1 ON T0.ItemCode = T1.ItemCode
INNER JOIN OWTQ T2 ON T1.DocEntry = T2.DocEntry
WHERE T0.[ItmsGrpCod] between '110' and '114'
and T2.[DocDueDate] = '[%0]'
GROUP BY T0.[ItemCode], T0.[ItemName], T0.[OnHand]
Ojala le sirva.
Atte. Rosa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hola
prueba esta sentencia:
SELECT T0.[ItemCode], T0.[ItemName], SUM(T0.[OnHand]) AS Stock, SUM(T1.[Quantity]) AS Cantidad
FROM OITM T0 INNER JOIN WTQ1 T1 ON T0.ItemCode = T1.ItemCode INNER JOIN OWTQ T2 ON T1.DocEntry = T2.DocEntry
WHERE T0.[ItmsGrpCod] between '110' and '114' and T2.[DocDueDate] =[%0]
Group by T0.[ItemCode], T0.[ItemName]
having sum(T1.[Quantity]) > 0
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 |
---|---|
103 | |
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.