0
Cargando...
Tente isso, você pode adicionar mais campos, isso é apenas totais por dia e por linha.
DECLARE @FechaIni DATETIME
DECLARE @FechaFin DATETIME
SET @FechaIni = '20090401'
SET @FechaFin = '20090430'
SELECT odln.DocDate AS [Fecha Pedido],
SUM(dln1.LineTotal) AS [Entregado],
SUM(RDR1.LineTotal) AS [Pedido]
FROM RDR1
LEFT OUTER JOIN DLN1 ON RDR1.TrgetEntry = DLN1.DocEntry AND RDR1.LineNum = DLN1.BaseLine
LEFT OUTER JOIN ORDR ON RDR1.DocEntry = ORDR.DocEntry
LEFT OUTER JOIN ODLN ON DLN1.DocEntry = ODLN.DocEntry
WHERE ORDR.Canceled = 'N' AND RDR1.DocEntry IN (
SELECT DocEntry FROM RDR1 WHERE TrgetEntry IN (
SELECT DocEntry FROM DLN1 WHERE DocDate BETWEEN @FechaIni AND @FechaFin GROUP BY DocEntry))
GROUP BY ODLN.DocDate
ORDER BY 1
Respondido el 15/04/2024
LUCIANO RIOJA GHIOTTO
Se unió el 13/07/2019
