on 04-12-2018 2:59 AM
Tengo que realizar un reporte en crystal report de ventas diarias por numero de serie, que muestre el pago, si se hizo por cheque, transferencia, efectivo, tengo que parametrizar un rango de fechas de los dias que quiero ver, soy nuevo en el mundo de sap pero deseo aprender a realizarlo.
ya logre hacer mi query pero todavia me faltan algunos datos, cashsum, checksum, trnsfrsum que estan en una tercera tabla nnm1, me podran echar una mano,
el ultimo select me da error, alguien me puede apoyar
SELECT t0.cardcode, t0.cardname, t0.docdate, t1.seriesname, t0.docnum, T0.Doctotal-t0.vatsum as 'Neto', T0.DocTotal
FROM OINV T0
INNER JOIN NNM1 T1 ON T0.Series = T1.Series
group by t1.seriesname, t0.cardcode, t0.cardname, t0.docdate, t0.docnum,T0.Doctotal-t0.vatsum, T0.DocTotal
union all
SELECT t0.cardcode, t0.cardname, t0.docdate, t1.seriesname, t0.docnum, (T0.Doctotal-t0.vatsum)*-1 as 'Neto', T0.DocTotal
FROM ORIN T0
INNER JOIN NNM1 T1 ON T0.Series = T1.Series
group by t1.seriesname, t0.cardcode, t0.cardname, t0.docdate, t0.docnum,T0.Doctotal-t0.vatsum, T0.DocTotal
union all
SELECT T2.cardcode, T2.cardname,T2.DocDate,t1.seriesname,T2.DOCNUM,(T2.Doctotal-t2.vatsum)*-1 as 'Neto',T2.DocTotal, T2.Cashsum, T2.creditsum,T2.checksum, T2.TrsfrSum
from ORCT T2
INNER JOIN NNM1 T1 ON T2.SERIES=T1.Series
group by T2.cardcode, T2.cardname,T2.DocDate,t1.seriesname,T2.DOCNUM,(T2.Doctotal-t2.vatsum)*-1,T2.DocTotal, T2.Cashsum, T2.creditsum,T2.checksum, T2.TrsfrSum ORDER BY t2.docdate
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
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.