on 06-20-2014 6:31 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
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.