07/02/2021 17:22:11  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->sigesp_apr_c_salcontables MÉTODO->uf_procesar_apertura_ejercicio ERROR->Invalid query: ERROR:  column sal.saldo_ant does not exist
LINE 4:            sal.saldo_ant,
                   ^
Whole query: 
		                  SELECT sal.sc_cuenta,
								   denominacion,
								   sal.saldo_ant,
								   sal.debe,
								   sal.haber,
								   sal.saldo_intervalo,
								   sal.saldo_act
							FROM
							(
								SELECT sc_cuenta,
									   round(COALESCE(sum(round(saldo_anterior::numeric,2)),0)::numeric,2) AS saldo_anterior,
									   round(COALESCE(sum(round(debe::numeric,2)),0)::numeric,2) AS debe,
									   round(COALESCE(sum(round(haber::numeric,2)),0)::numeric,2) AS haber,
									   round(COALESCE(sum(round(saldo_intervalo::numeric,2)),0)::numeric,2) AS saldo_intervalo,
									   round(COALESCE(sum(round(saldo_actual::numeric,2)),0)::numeric,2) AS saldo_actual
								FROM
								(
									SELECT sc_cuenta,saldo_anterior,0 AS debe,0 AS haber,0 AS saldo_intervalo,0 as saldo_actual
									FROM
									(
										SELECT sc_cuenta,round((COALESCE(sum(round(debe::numeric,2)),0)-COALESCE(sum(round(haber::numeric,2)),0))::numeric,2) AS saldo_anterior
										FROM(
											SELECT dt.sc_cuenta,COALESCE(sum(round(dt.monto::numeric,2)),0) AS debe, 0 AS haber  
											FROM scg_dt_cmp dt
											INNER JOIN scg_cuentas c ON (dt.sc_cuenta) = (c.sc_cuenta)
														AND dt.codemp = c.codemp
											WHERE dt.debhab='D'
											  AND dt.codemp = '0001'
											  AND dt.fecha < '2020-01-01'
											GROUP BY dt.sc_cuenta
											UNION ALL
											SELECT dt.sc_cuenta, 0 AS debe, COALESCE(sum(round(dt.monto::numeric,2)),0) AS haber  
											FROM scg_dt_cmp dt
											INNER JOIN scg_cuentas c ON (dt.sc_cuenta) = (c.sc_cuenta)
														AND dt.codemp = c.codemp
											WHERE  dt.debhab='H'
											  AND dt.codemp = '0001'
											  AND dt.fecha < '2020-01-01'						  
											GROUP BY dt.sc_cuenta
										) AS saldos
										GROUP BY sc_cuenta
									) anterior
									WHERE saldo_anterior!=0	
									UNION
									SELECT sc_cuenta,0 as saldo_anterior,0 AS debe,0 AS haber,0 AS saldo_intervalo,saldo_actual
									FROM
									(
										SELECT sc_cuenta,round((COALESCE(sum(round(debe::numeric,2)),0)-COALESCE(sum(round(haber::numeric,2)),0))::numeric,2) AS saldo_actual
										FROM(
											SELECT dt.sc_cuenta,COALESCE(sum(round(dt.monto::numeric,2)),0) AS debe, 0 AS haber  
											FROM scg_dt_cmp dt
											INNER JOIN scg_cuentas c ON (dt.sc_cuenta) = (c.sc_cuenta)
														AND dt.codemp = c.codemp
											WHERE dt.debhab='D'
											  AND dt.codemp = '0001'
											  AND dt.fecha <= '2020-12-31'
											GROUP BY dt.sc_cuenta
											UNION ALL
											SELECT dt.sc_cuenta, 0 AS debe, COALESCE(sum(round(dt.monto::numeric,2)),0) AS haber  
											FROM scg_dt_cmp dt
											INNER JOIN scg_cuentas c ON (dt.sc_cuenta) = (c.sc_cuenta)
														AND dt.codemp = c.codemp
											WHERE  dt.debhab='H'
											  AND dt.codemp = '0001'
											  AND dt.fecha <= '2020-12-31'							  
											GROUP BY dt.sc_cuenta
										) AS saldos
										GROUP BY sc_cuenta
									) actual
									WHERE saldo_actual!=0	
									UNION
									SELECT sc_cuenta,0 as saldo_anterior, debe, haber, saldo_intervalo, 0 AS saldo_actual
									FROM
									(
										SELECT sc_cuenta,
											   round(COALESCE(sum(round(debe::numeric,2)),0)::numeric,2) AS debe,
											   round(COALESCE(sum(round(haber::numeric,2)),0)::numeric,2) AS haber,
											   round((COALESCE(sum(round(debe::numeric,2)),0)-COALESCE(sum(round(haber::numeric,2)),0))::numeric,2) AS saldo_intervalo
										FROM(
											SELECT dt.sc_cuenta,COALESCE(sum(round(dt.monto::numeric,2)),0) AS debe, 0 AS haber  
											FROM scg_dt_cmp dt
											INNER JOIN scg_cuentas c ON (dt.sc_cuenta) = (c.sc_cuenta)
														AND dt.codemp = c.codemp
											WHERE dt.debhab='D'
											  AND dt.codemp = '0001'
											  AND dt.fecha BETWEEN '2020-01-01' AND '2020-12-31'
											GROUP BY dt.sc_cuenta
											UNION ALL
											SELECT dt.sc_cuenta, 0 AS debe, COALESCE(sum(round(dt.monto::numeric,2)),0) AS haber  
											FROM scg_dt_cmp dt
											INNER JOIN scg_cuentas c ON (dt.sc_cuenta) = (c.sc_cuenta)
														AND dt.codemp = c.codemp
											WHERE  dt.debhab='H'
											  AND dt.codemp = '0001'
											  AND dt.fecha BETWEEN '2020-01-01' AND '2020-12-31'						  
											GROUP BY dt.sc_cuenta
										) AS saldos	
										GROUP BY sc_cuenta
									) intervalo
									WHERE saldo_intervalo!=0
									ORDER BY 1
								) AS saldos
								GROUP BY sc_cuenta
								ORDER BY 1
							) AS sal
							INNER JOIN scg_cuentas ctas ON sal.sc_cuenta=ctas.sc_cuenta
							WHERE saldo_actual!=0
							ORDER BY 1