26/08/2021 15:38:01  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cxc_c_reportes <br><b>METODO:</b> ConsultaFacturacionBrutaMensual <br><b>ERROR-></b><br>Invalid query: ERROR:  missing FROM-clause entry for table "d"
LINE 282:              sum(d.neto_detalle/tascam) as total_nov,
                           ^
Whole query:  
			            SELECT tipopeneg AS codsuc,
							   desctipopeneg AS sigsuc,
							   codmon,
							   sum(total_ene) AS total_ene,
							   sum(total_feb) AS total_feb,
							   sum(total_mar) AS total_mar,
							   sum(total_abr) AS total_abr,
							   sum(total_may) AS total_may,
							   sum(total_jun) AS total_jun,
							   sum(total_jul) AS total_jul,
							   sum(total_ago) AS total_ago,
							   sum(total_sep) AS total_sep,
							   sum(total_oct) AS total_oct,
							   sum(total_nov) AS total_nov,
							   sum(total_dic) AS total_dic
						FROM
						(     
									SELECT f.tipopeneg AS tipopeneg,
										   MAX(desctipopeneg) AS desctipopeneg,
										   f.codmon,
										   sum(d.neto_detalle/tascam) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										   sum(0) as total_abr,
										   sum(0) as total_may,
										   sum(0) as total_jun,
										   sum(0) as total_jul,
										   sum(0) as total_ago,
										   sum(0) as total_sep,
										   sum(0) as total_oct,
										   sum(0) as total_nov,
										   sum(0) as total_dic
									FROM cxc_factura f
									INNER JOIN cxc_detalle d ON f.id_fact = d.id_fact
									INNER JOIN cxc_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									WHERE f.fecfact BETWEEN '2021-01-01' AND '2021-01-31'
									  AND f.id_estfact!=7
									   AND d.id_tipodetalle = 'SERVI' 
									GROUP BY f.tipopeneg,f.codmon
									UNION															
									SELECT f.tipopeneg AS tipopeneg,
										   MAX(desctipopeneg) AS desctipopeneg,
										   f.codmon,
										   sum(0) AS total_ene,
										   sum(d.neto_detalle/tascam) as total_feb,
										   sum(0) as total_mar,
										   sum(0) as total_abr,
										   sum(0) as total_may,
										   sum(0) as total_jun,
										   sum(0) as total_jul,
										   sum(0) as total_ago,
										   sum(0) as total_sep,
										   sum(0) as total_oct,
										   sum(0) as total_nov,
										   sum(0) as total_dic
									FROM cxc_factura f
									INNER JOIN cxc_detalle d ON f.id_fact = d.id_fact
									INNER JOIN cxc_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									WHERE f.fecfact BETWEEN '2021-02-01' AND '2021-02-28'
									  AND f.id_estfact!=7
									   AND d.id_tipodetalle = 'SERVI' 
									GROUP BY f.tipopeneg,f.codmon
									UNION									
									SELECT f.tipopeneg AS tipopeneg,
										   MAX(desctipopeneg) AS desctipopeneg,
										   f.codmon,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(d.neto_detalle/tascam) as total_mar,
										   sum(0) as total_abr,
										   sum(0) as total_may,
										   sum(0) as total_jun,
										   sum(0) as total_jul,
										   sum(0) as total_ago,
										   sum(0) as total_sep,
										   sum(0) as total_oct,
										   sum(0) as total_nov,
										   sum(0) as total_dic
									FROM cxc_factura f
									INNER JOIN cxc_detalle d ON f.id_fact = d.id_fact
									INNER JOIN cxc_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									WHERE f.fecfact BETWEEN '2021-03-01' AND '2021-03-31'
									  AND f.id_estfact!=7
									   AND d.id_tipodetalle = 'SERVI' 
									GROUP BY f.tipopeneg,f.codmon
									UNION									
									SELECT f.tipopeneg AS tipopeneg,
										   MAX(desctipopeneg) AS desctipopeneg,
										   f.codmon,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										   sum(d.neto_detalle/tascam) as total_abr,
										   sum(0) as total_may,
										   sum(0) as total_jun,
										   sum(0) as total_jul,
										   sum(0) as total_ago,
										   sum(0) as total_sep,
										   sum(0) as total_oct,
										   sum(0) as total_nov,
										   sum(0) as total_dic
									FROM cxc_factura f
									INNER JOIN cxc_detalle d ON f.id_fact = d.id_fact
									INNER JOIN cxc_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									WHERE f.fecfact BETWEEN '2021-04-01' AND '2021-04-30'
									  AND f.id_estfact!=7
									   AND d.id_tipodetalle = 'SERVI' 
									GROUP BY f.tipopeneg,f.codmon
									UNION									
									SELECT f.tipopeneg AS tipopeneg,
										   MAX(desctipopeneg) AS desctipopeneg,
										   f.codmon,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										   sum(0) as total_abr,
										   sum(d.neto_detalle/tascam) as total_may,
										   sum(0) as total_jun,
										   sum(0) as total_jul,
										   sum(0) as total_ago,
										   sum(0) as total_sep,
										   sum(0) as total_oct,
										   sum(0) as total_nov,
										   sum(0) as total_dic
									FROM cxc_factura f
									INNER JOIN cxc_detalle d ON f.id_fact = d.id_fact
									INNER JOIN cxc_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									WHERE f.fecfact BETWEEN '2021-05-01' AND '2021-05-31'
									  AND f.id_estfact!=7
									   AND d.id_tipodetalle = 'SERVI' 
									GROUP BY f.tipopeneg,f.codmon															
									UNION
									SELECT f.tipopeneg AS tipopeneg,
										   MAX(desctipopeneg) AS desctipopeneg,
										   f.codmon,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										   sum(0) as total_abr,
										   sum(0) as total_may,
										   sum(d.neto_detalle/tascam) as total_jun,
										   sum(0) as total_jul,
										   sum(0) as total_ago,
										   sum(0) as total_sep,
										   sum(0) as total_oct,
										   sum(0) as total_nov,
										   sum(0) as total_dic
									FROM cxc_factura f
									INNER JOIN cxc_detalle d ON f.id_fact = d.id_fact
									INNER JOIN cxc_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									WHERE f.fecfact BETWEEN '2021-06-01' AND '2021-06-30'
									  AND f.id_estfact!=7
									   AND d.id_tipodetalle = 'SERVI' 
									GROUP BY f.tipopeneg,f.codmon
									UNION									
									SELECT f.tipopeneg AS tipopeneg,
										   MAX(desctipopeneg) AS desctipopeneg,
										   f.codmon,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										   sum(0) as total_abr,
										   sum(0) as total_may,
										   sum(0) as total_jun,
										   sum(d.neto_detalle/tascam) as total_jul,
										   sum(0) as total_ago,
										   sum(0) as total_sep,
										   sum(0) as total_oct,
										   sum(0) as total_nov,
										   sum(0) as total_dic
									FROM cxc_factura f
									INNER JOIN cxc_detalle d ON f.id_fact = d.id_fact
									INNER JOIN cxc_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									WHERE f.fecfact BETWEEN '2021-07-01' AND '2021-07-31'
									  AND f.id_estfact!=7
									   AND d.id_tipodetalle = 'SERVI' 
									GROUP BY f.tipopeneg,f.codmon
									UNION									
									SELECT f.tipopeneg AS tipopeneg,
										   MAX(desctipopeneg) AS desctipopeneg,
										   f.codmon,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										   sum(0) as total_abr,
										   sum(0) as total_may,
										   sum(0) as total_jun,
										   sum(0) as total_jul,
										   sum(d.neto_detalle/tascam) as total_ago,
										   sum(0) as total_sep,
										   sum(0) as total_oct,
										   sum(0) as total_nov,
										   sum(0) as total_dic
									FROM cxc_factura f
									INNER JOIN cxc_detalle d ON f.id_fact = d.id_fact
									INNER JOIN cxc_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									WHERE f.fecfact BETWEEN '2021-08-01' AND '2021-08-31'
									  AND f.id_estfact!=7
									   AND d.id_tipodetalle = 'SERVI' 
									GROUP BY f.tipopeneg,f.codmon
									UNION									
									SELECT f.tipopeneg AS tipopeneg,
										   MAX(desctipopeneg) AS desctipopeneg,
										   f.codmon,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										   sum(0) as total_abr,
										   sum(0) as total_may,
										   sum(0) as total_jun,
										   sum(0) as total_jul,
										   sum(0) as total_ago,
										   sum(d.neto_detalle/tascam) as total_sep,
										   sum(0) as total_oct,
										   sum(0) as total_nov,
										   sum(0) as total_dic
									FROM cxc_factura f
									INNER JOIN cxc_detalle d ON f.id_fact = d.id_fact
									INNER JOIN cxc_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									WHERE f.fecfact BETWEEN '2021-09-01' AND '2021-09-30'
									  AND f.id_estfact!=7
									   AND d.id_tipodetalle = 'SERVI' 
									GROUP BY f.tipopeneg,f.codmon
									UNION
									SELECT f.tipopeneg AS tipopeneg,
										   MAX(desctipopeneg) AS desctipopeneg,
										   f.codmon,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										   sum(0) as total_abr,
										   sum(0) as total_may,
										   sum(0) as total_jun,
										   sum(0) as total_jul,
										   sum(0) as total_ago,
										   sum(0) as total_sep,
										   sum(d.neto_detalle/tascam) as total_oct,
										   sum(0) as total_nov,
										   sum(0) as total_dic
									FROM cxc_factura f
									INNER JOIN cxc_detalle d ON f.id_fact = d.id_fact
									INNER JOIN cxc_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									WHERE f.fecfact BETWEEN '2021-10-01' AND '2021-10-31'
									  AND f.id_estfact!=7
									   AND d.id_tipodetalle = 'SERVI' 
									GROUP BY f.tipopeneg,f.codmon
									UNION									
									SELECT f.tipopeneg AS tipopeneg,
										   MAX(desctipopeneg) AS desctipopeneg,
										   f.codmon,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										   sum(0) as total_abr,
										   sum(0) as total_may,
										   sum(0) as total_jun,
										   sum(0) as total_jul,
										   sum(0) as total_ago,
										   sum(0) as total_sep,
										   sum(0) as total_oct,
										   sum(d.neto_detalle/tascam) as total_nov,
										   sum(0) as total_dic
									FROM cxc_factura f
									INNER JOIN cxc_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									WHERE f.fecfact BETWEEN '2021-11-01' AND '2021-11-30'
									  AND f.id_estfact!=7
									   AND d.id_tipodetalle = 'SERVI' 
									GROUP BY f.tipopeneg,f.codmon	
									UNION								
									SELECT f.tipopeneg AS tipopeneg,
										   MAX(desctipopeneg) AS desctipopeneg,
										   f.codmon,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										   sum(0) as total_abr,
										   sum(0) as total_may,
										   sum(0) as total_jun,
										   sum(0) as total_jul,
										   sum(0) as total_ago,
										   sum(0) as total_sep,
										   sum(0) as total_oct,
										   sum(0) as total_nov,
										   sum(d.neto_detalle/tascam) as total_dic
									FROM cxc_factura f
									INNER JOIN cxc_detalle d ON f.id_fact = d.id_fact
									INNER JOIN cxc_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									WHERE f.fecfact BETWEEN '2021-12-01' AND '2021-12-31'
									  AND f.id_estfact!=7
									   AND d.id_tipodetalle = 'SERVI' 
									GROUP BY f.tipopeneg,f.codmon								
									
						) AS  fac
						GROUP BY codsuc,sigsuc,codmon
						ORDER BY codmon,codsuc	
					  

26/08/2021 17:51:27  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001

26/08/2021 17:53:02  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001

26/08/2021 17:55:00  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001

26/08/2021 17:55:23  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001

26/08/2021 17:55:37  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001

26/08/2021 17:56:16  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001

26/08/2021 17:56:43  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001

26/08/2021 17:58:47  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001

26/08/2021 18:01:02  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001

26/08/2021 18:02:19  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001

26/08/2021 18:03:33  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001

26/08/2021 18:04:00  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001

26/08/2021 18:04:23  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001

26/08/2021 18:06:14  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001

26/08/2021 18:08:44  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001

26/08/2021 18:10:51  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El movimiento contable SCGCIE-0000CIERRE-2020 ya existe. Cta: 325020000000001