cancel
Showing results for 
Search instead for 
Did you mean: 

Informe de Depositos en Caja

Former Member
0 Kudos

Buenos dias;

Como puedo realizar informe de los depositos realizados en caja.

Tengo el query con la tabla ODPS y las lineas no se que tabla sera, para depositos de cheque si me aparece. pero para depositos de caja no se que tabla tomar.

en espera de su ayuda.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Buenas intenta con esta consulta

SELECT T0.[DocNum] AS "R-CAJA", T1.DocDate,'1. Contado' as TIPO,SUM(T1.CashSum)AS "EFECTIVO",

SUM(T1.CreditSum) AS "TARJETA",SUM(T1.TrsfrSum) AS "TRANSFERENCIA",SUM(T2.CheckSum) as "VALOR CHEQUE",0 AS "ANTICIPO",

T2.U_Aprobacion AS "AUTORIZACION",T1.CashAcct,T1.TrsfrAcct,

T3.BankName AS "BANCO", T5.AcctName as "BANCO_TRAN",

case when SUM(T1.CashSum)>0 then t4.AcctName else null end AS "BANCO_EFEC",

CASE when T2.BankCode <>'' then T1.DocDate else T2.CheckNum  end AS "FECHA CHEQUE", T2.CheckNum AS "NUMERO DE CHEQUE",

SUM(T1.CashSum) AS "ENTRADA EFECTIVO",SUM(T1.CreditSum) AS "ENTRADA TARJETA",SUM(T1.TrsfrSum) AS "ENTRADA TRANS",SUM(T2.CheckSum) as "ENTRADA CHEQUE",

NULL AS "SALIDA EFECTIVO",NULL AS "SALIDA TARJETA",NULL AS "SALIDA TRANS",NULL as "SALIDA CHEQUE"

INTO #RCAJA1

FROM RCT2 T0

INNER JOIN ORCT T1 ON T0.DocNum = T1.DocEntry

LEFT JOIN RCT1 T2 ON T1.DocEntry=T2.DocNum

LEFT JOIN ODSC T3 ON T2.BankCode=T3.BankCode

LEFT JOIN OACT T4 ON T1.CashAcct=T4.AcctCode

LEFT JOIN OACT T5 ON T1.TrsfrAcct=T5.AcctCode

WHERE T1.[DocDate] between @fecha1 and @fecha2

group by T0.[DocNum],T1.DocDate,T2.U_Aprobacion,T1.CashAcct,T1.TrsfrAcct,T5.AcctName,T4.AcctName,T3.BankName,T1.DocDate,T2.BankCode,T2.CheckNum