14/07/2015 23:21:00 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_cuentasxcobrar
METODO: ConsultaIngresosCajaInvalid query: ERROR: error de sintaxis en o cerca de ĞIğ LINE 18: I INNER JOIN cxc_factura f ON mc.tipdoc = 'FA... ^ Whole query: SELECT * FROM cxc_ingresos ing INNER JOIN cxc_formapago fp ON fp.codforpag = ing.codforpag INNER JOIN cxc_sucursales suc ON suc.codemp = ing.codemp AND suc.codsuc = ing.codsuc INNER JOIN cxc_esting ei ON ei.esting = ing.esting INNER JOIN cxc_cajas caj ON caj.codemp = ing.codemp AND caj.codsuc = ing.codsuc AND caj.codcaj = ing.codcaj LEFT JOIN cxc_clientes c ON c.id_cliente = ing.id_cliente LEFT JOIN sigesp_moneda mo ON ing.codmon = mo.codmon LEFT JOIN cxc_bancos b ON b.codban = ing.codbancli LEFT JOIN scb_banco be ON be.codemp = ing.codemp AND be.codban = ing.codban LEFT JOIN scb_ctabanco cbe ON cbe.codemp = ing.codemp AND cbe.codban = ing.codban AND cbe.ctaban = ing.ctaban WHERE ing.codemp='0001' AND ing.fecing BETWEEN '2006-07-01' AND '2015-07-14' AND ing.codsuc||ing.codcaj||ing.nroing IN ( SELECT mc.codsuc||mc.codcaj||mc.nroing FROM cxc_dt_movcobro mc I INNER JOIN cxc_factura f ON mc.tipdoc = 'FACT' AND mc.id_doc = f.id_fact WHERE f.numfact = '180' ) ORDER BY ing.codsuc,ing.codcaj,ing.nroing