28/02/2022 19:36:03  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cre_c_reportes <br><b>METODO:</b> ConsultaIngresoFormaPago <br><b>ERROR-></b><br>Invalid query: 
Whole query: 

28/02/2022 19:37:49  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cre_c_reportes <br><b>METODO:</b> ConsultaIngresoFormaPago <br><b>ERROR-></b><br>Invalid query: ERROR:  column ing.id_suc does not exist
LINE 15: ...    INNER JOIN cre_sucursales suc ON suc.id_suc = ing.id_suc
                                                              ^
Whole query:        SELECT ing.codforpag,
										   MAX(fp.denforpag) as denforpag,										   
										   COALESCE(sum(moning),0) AS moning,
										   COALESCE(sum(moningcap),0) AS moningcap,
										   COALESCE(sum(moningint),0) AS moningint,
										   COALESCE(sum(moningintmora),0) AS moningintmora,
										   COALESCE(sum(moningintdif),0) AS moningintdif,
										   COALESCE(sum(moningintdesemb),0) AS moningintdesemb,
										   COALESCE(sum(moningaboext),0) AS moningaboext,
										   COALESCE(sum(moningant),0) AS moningant,
										   COALESCE(sum(moningotros),0) AS moningotros								   
									  FROM cxc_ingresos ing
									  INNER JOIN cre_formapago fp ON fp.codforpag = ing.codforpag
					                  INNER JOIN cre_esting ei ON ei.esting = ing.esting
					                  INNER JOIN cre_sucursales suc ON suc.id_suc = ing.id_suc
								      INNER JOIN cre_cajas caj ON caj.id_suc = ing.id_suc
															  AND caj.id_caja = ing.id_caja
									  INNER JOIN cre_cliente cl ON cl.id_cliente = ing.id_cliente
									  LEFT JOIN cre_empresa e ON e.id_empresa=cl.id_empresa 
									  LEFT JOIN cre_persona p ON p.id_persona=cl.id_persona
									  LEFT JOIN cre_bancos b ON b.codban = ing.codbancli 
									  LEFT JOIN sigesp_moneda m ON m.codmon=ing.codmon
									  WHERE e.nombre_empresa ILIKE'%%' 									  
									   AND ing.esting != 'ANU'  AND ing.fecing BETWEEN '2000-02-28' AND '2022-02-28'   AND ing.codmon = 'USD'  
									  GROUP BY ing.codforpag
									  ORDER BY ing.codforpag