Skip to Content
0

Corte de Caja Diario por serie

Apr 12 at 01:59 AM

32

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Apr 13 at 03:55 PM
0

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
Share
10 |10000 characters needed characters left characters exceeded