20/06/2021 12:17:57  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cxc_c_reportes <br><b>METODO:</b> ConsultaFacturacionNetaMensualMonref <br><b>ERROR-></b><br>Invalid query: ERROR:  column "codmon" does not exist
LINE 905:          ORDER BY codmon,codmonref
                            ^
Whole query:  
			            SELECT codsuc,
							   sigsuc,
							   codmonref as 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 s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   sum(total/tascamref) 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_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									WHERE f.fecfact BETWEEN '2020-01-01' AND '2020-01-31'
									  AND f.id_estfact!=7
									  
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   -sum(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-01-01' AND '2020-01-31'
									   AND codtipdoc='NC'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   sum(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-01-01' AND '2020-01-31'
									   AND codtipdoc='ND'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref							
									UNION	
															
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   sum(0) AS total_ene,
										   sum(total/tascamref) 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_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									WHERE f.fecfact BETWEEN '2020-02-01' AND '2020-02-29'
									  AND f.id_estfact!=7
									  
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   sum(0) AS total_ene,
										  -sum(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-02-01' AND '2020-02-29'
									   AND codtipdoc='NC'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   sum(0) AS total_ene,
										   sum(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-02-01' AND '2020-02-29'
									   AND codtipdoc='ND'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref									
									UNION
									
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(total/tascamref) 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_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									WHERE f.fecfact BETWEEN '2020-03-01' AND '2020-03-31'
									  AND f.id_estfact!=7
									  
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										  -sum(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-03-01' AND '2020-03-31'
									   AND codtipdoc='NC'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-03-01' AND '2020-03-31'
									   AND codtipdoc='ND'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref							
									UNION
									
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										   sum(total/tascamref) 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_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									WHERE f.fecfact BETWEEN '2020-04-01' AND '2020-04-30'
									  AND f.id_estfact!=7
									  
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										  -sum(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-04-01' AND '2020-04-30'
									   AND codtipdoc='NC'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										   sum(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-04-01' AND '2020-04-30'
									   AND codtipdoc='ND'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref							
									UNION
									
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										   sum(0) as total_abr,
										   sum(total/tascamref) 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_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									WHERE f.fecfact BETWEEN '2020-05-01' AND '2020-05-31'
									  AND f.id_estfact!=7
									  
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										   sum(0) as total_abr,
										  -sum(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-05-01' AND '2020-05-31'
									   AND codtipdoc='NC'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   sum(0) AS total_ene,
										   sum(0) as total_feb,
										   sum(0) as total_mar,
										   sum(0) as total_abr,
										   sum(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-05-01' AND '2020-05-31'
									   AND codtipdoc='ND'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref							
									UNION
									
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total/tascamref) 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_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									WHERE f.fecfact BETWEEN '2020-06-01' AND '2020-06-30'
									  AND f.id_estfact!=7
									  
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-06-01' AND '2020-06-30'
									   AND codtipdoc='NC'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-06-01' AND '2020-06-30'
									   AND codtipdoc='ND'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref							
									UNION
									
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total/tascamref) 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_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									WHERE f.fecfact BETWEEN '2020-07-01' AND '2020-07-31'
									  AND f.id_estfact!=7
									  
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-07-01' AND '2020-07-31'
									   AND codtipdoc='NC'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-07-01' AND '2020-07-31'
									   AND codtipdoc='ND'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref							
									UNION
									
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total/tascamref) 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_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									WHERE f.fecfact BETWEEN '2020-08-01' AND '2020-08-31'
									  AND f.id_estfact!=7
									  
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-08-01' AND '2020-08-31'
									   AND codtipdoc='NC'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total_doc/f.tascamref) 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_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-08-01' AND '2020-08-31'
									   AND codtipdoc='ND'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref							
									UNION
									
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total/tascamref) 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_sucursales s ON s.codsuc = f.codsuc
									LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = s.coduniejesuc
									WHERE f.fecfact BETWEEN '2020-09-01' AND '2020-09-30'
									  AND f.id_estfact!=7
									  
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total_doc/f.tascamref) as total_sep,
										   sum(0) as total_oct,
										   sum(0) as total_nov,
										   sum(0) as total_dic
									FROM cxc_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-09-01' AND '2020-09-30'
									   AND codtipdoc='NC'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total_doc/f.tascamref) as total_sep,
										   sum(0) as total_oct,
										   sum(0) as total_nov,
										   sum(0) as total_dic
									FROM cxc_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-09-01' AND '2020-09-30'
									   AND codtipdoc='ND'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref							
									UNION
									
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total/tascamref) as total_oct,
										   sum(0) 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
									WHERE f.fecfact BETWEEN '2020-10-01' AND '2020-10-31'
									  AND f.id_estfact!=7
									  
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total_doc/f.tascamref) as total_oct,
										   sum(0) as total_nov,
										   sum(0) as total_dic
									FROM cxc_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-10-01' AND '2020-10-31'
									   AND codtipdoc='NC'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total_doc/f.tascamref) as total_oct,
										   sum(0) as total_nov,
										   sum(0) as total_dic
									FROM cxc_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-10-01' AND '2020-10-31'
									   AND codtipdoc='ND'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref							
									UNION
									
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total/tascamref) 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
									WHERE f.fecfact BETWEEN '2020-11-01' AND '2020-11-30'
									  AND f.id_estfact!=7
									  
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total_doc/f.tascamref) as total_nov,
										   sum(0) as total_dic
									FROM cxc_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-11-01' AND '2020-11-30'
									   AND codtipdoc='NC'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total_doc/f.tascamref) as total_nov,
										   sum(0) as total_dic
									FROM cxc_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-11-01' AND '2020-11-30'
									   AND codtipdoc='ND'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref							
									UNION
									
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total/tascamref) 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
									WHERE f.fecfact BETWEEN '2020-12-01' AND '2020-12-31'
									  AND f.id_estfact!=7
									  
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total_doc/f.tascamref) as total_dic
									FROM cxc_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-12-01' AND '2020-12-31'
									   AND codtipdoc='NC'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref
									UNION
									SELECT s.codsuc,
										   s.sigsuc,
										   f.codmonref,
										   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(total_doc/f.tascamref) as total_dic
									FROM cxc_documento d
									INNER JOIN cxc_factura f 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
									 WHERE d.fecdoc BETWEEN '2020-12-01' AND '2020-12-31'
									   AND codtipdoc='ND'
									   AND estdoccxc!='A'
									   
									GROUP BY s.codsuc,s.sigsuc,f.codmonref							
									ORDER BY codmon,codmonref
						) AS  fac
						GROUP BY codsuc,sigsuc,codmonref
						ORDER BY codmon,codmonref