Skip to Content
avatar image
Former Member

Corte de Caja Diario por serie

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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
    
    Add comment
    10|10000 characters needed characters exceeded