14/06/2021 02:48:01  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> BuscarMontoCobradoCxc <br><b>ERROR-></b><br>Invalid query: ERROR:  column cob.monmovcob does not exist
LINE 1:   SELECT COALESCE(sum(cob.monmovcob),0) as moncobtot,
                              ^
Whole query:   SELECT COALESCE(sum(cob.monmovcob),0) as moncobtot,
									COALESCE(sum(cob.moncobret),0) as moncobret, 
									COALESCE(sum(cob.moncobant),0) as moncobant 
				              FROM
							 (								 
								 SELECT sum(mc.monmovcob) as moncobtot,
									    sum(mc.moncobret) as moncobret, 
									    sum(mc.moncobant) as moncobant 
								 FROM cxc_dt_movcobro mc 
								 INNER JOIN cxc_factura f ON f.codemp = mc.codemp 
											AND f.id_fact = mc.id_doc
								 INNER JOIN cxc_clientes c ON c.id_cliente = f.id_cliente
								 INNER JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
								 WHERE mc.fecmovcob<='2021-03-31'
								   AND mc.tipdoc='FACT'
								  AND f.tipopecont='DEV'  AND f.id_cliente = '7'  AND (f.nro_ticket='' OR f.nro_ticket IS NULL) 
							     UNION ALL
							     SELECT -sum(mc.monmovcob) as moncobtot,
								  	    -sum(mc.moncobret) as moncobret, 
									    -sum(mc.moncobant) as moncobant 
							     FROM cxc_dt_movcobro mc 
								 INNER JOIN cxc_factura f ON f.codemp = mc.codemp 
													     AND f.id_fact = mc.id_doc
								 INNER JOIN cxc_clientes c ON c.id_cliente = f.id_cliente
								 INNER JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
								 WHERE mc.fecanucob<='2021-03-31' 
								   AND mc.estmovcob='ANU'
								   AND tipdoc='FACT'
								  AND f.tipopecont='DEV'  AND f.id_cliente = '7'  AND (f.nro_ticket='' OR f.nro_ticket IS NULL) 
								) AS cob