10/03/2022 15:23:59  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> ConsultaAnticipoInvalid query: ERROR:  function round(double precision, integer) does not exist
LINE 6:            round(a.monant,8) as monant, 
                   ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Whole query: SELECT  
						     a.codemp, a.idant, a.id_cliente, a.nroant, a.nroproy, a.nrocontrato, 
						     a.scg_cuenta_ant, 
						     a.fecant, a.conant, a.porant, a.codmon, 
						     a.tascam AS tascam, 
						     round(a.monant,8) as monant, 
						     a.estant, 
						     a.fecanuant, 
						     a.conanuant, a.fecregant, a.usuregant, a.horaregant, 
						     a.nroing, a.codsucres, 
						     a.codcajres, a.resing, a.codmonref, a.tascamref,						     
					         cl.*,mo.*,e.*,
					         round((
									a.monant
									-
									( SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0) 
									  FROM cxc_dt_anticipos da 
									  INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
													AND da.id_cliente = ant.id_cliente
													AND da.nroant = ant.nroant
													AND ant.estant!='ANU'	
									  INNER JOIN cxc_factura f ON f.id_fact = da.id_fact		
									  WHERE da.codemp=a.codemp  
									  AND da.id_cliente=a.id_cliente
									  AND da.nroant=a.nroant
									  AND estdesc='P'
									 )
							
							)::numeric,8) AS saldo_ant,
							(
								SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0) 
							    FROM cxc_dt_anticipos da 
							    INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
											AND da.id_cliente = ant.id_cliente
											AND da.nroant = ant.nroant
											AND ant.estant!='ANU'
								INNER JOIN cxc_factura f ON f.id_fact = da.id_fact		
							    WHERE da.codemp=a.codemp 
							    AND da.id_cliente=a.id_cliente
							    AND da.nroant=a.nroant
							    AND estdesc='P'
							) AS ant_apl
						   
						     FROM cxc_anticipos a   INNER JOIN cxc_clientes cl ON cl.id_cliente = a.id_cliente
					                   INNER JOIN cxc_estanticipo e ON e.estant = a.estant
					                   LEFT JOIN sigesp_moneda mo ON a.codmon = mo.codmon	
					                   WHERE a.conant ILIKE('%%') 
									    
									   ORDER BY a.id_cliente, a.nroant 

10/03/2022 22:02:23  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> ConsultaAnticipoInvalid query: ERROR:  missing FROM-clause entry for table "ant"
LINE 47: ...       LEFT JOIN cxc_ingresos ing ON ing.codsuc = ant.codsuc...
                                                              ^
Whole query: SELECT  
						     a.codemp, a.idant, a.id_cliente, a.nroant, a.nroproy, a.nrocontrato, 
						     a.scg_cuenta_ant, 
						     a.fecant, a.conant, a.porant, a.codmon, 
						     a.tascam AS tascam, 
						     round(a.monant::numeric,8) as monant, 
						     a.estant, 
						     a.fecanuant, 
						     a.conanuant, a.fecregant, a.usuregant, a.horaregant, 
						     a.nroing, a.codsucres, 
						     a.codcajres, a.resing, a.codmonref, a.tascamref,						     
					         cl.*,mo.*,e.*,
					         round((
									a.monant
									-
									( SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0) 
									  FROM cxc_dt_anticipos da 
									  INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
													AND da.id_cliente = ant.id_cliente
													AND da.nroant = ant.nroant
													AND ant.estant!='ANU'	
									  INNER JOIN cxc_factura f ON f.id_fact = da.id_fact		
									  WHERE da.codemp=a.codemp  
									  AND da.id_cliente=a.id_cliente
									  AND da.nroant=a.nroant
									  AND estdesc='P'
									 )
							
							)::numeric,8) AS saldo_ant,
							(
								SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0) 
							    FROM cxc_dt_anticipos da 
							    INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
											AND da.id_cliente = ant.id_cliente
											AND da.nroant = ant.nroant
											AND ant.estant!='ANU'
								INNER JOIN cxc_factura f ON f.id_fact = da.id_fact		
							    WHERE da.codemp=a.codemp 
							    AND da.id_cliente=a.id_cliente
							    AND da.nroant=a.nroant
							    AND estdesc='P'
							) AS ant_apl
						   
						     FROM cxc_anticipos a   INNER JOIN cxc_clientes cl ON cl.id_cliente = a.id_cliente
					                   INNER JOIN cxc_estanticipo e ON e.estant = a.estant
					                   LEFT JOIN sigesp_moneda mo ON a.codmon = mo.codmon	
									   LEFT JOIN cxc_ingresos ing ON ing.codsuc = ant.codsucres 
																  AND ing.codcaj = ant.codcajres
																  AND ing.nroing = ant.resing
					                   WHERE a.conant ILIKE('%%') 
									    AND a.codmon = 'AWG'  AND a.estant != 'ANU'  AND a.fecant BETWEEN '2021-12-01' AND  '2022-03-10' AND (ing.aero_ticket='' OR ing.aero_ticket IS NULL) AND ing.id_fact_ticket=0  
									   ORDER BY a.codmon,a.id_cliente, a.nroant