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