29/08/2021 16:56:01  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cxc_c_reportes <br><b>METODO:</b> ConsultaMovimientosIngreso <br><b>ERROR-></b><br>Invalid query: ERROR:  invalid input syntax for type date: "--"
LINE 52:          WHERE mc.fecmovcob BETWEEN '--' AND '--'
                                             ^
Whole query:  							
															
								SELECT  
									   'COB FACT' AS tipmov,
										c.id_cliente AS id_cliente,
										c.nombre_cliente AS nombre_cliente,
										mc.codsuc AS codsuc,
										mc.codcaj AS codcaj,
										suc.coduniejesuc AS coduniejesuc,
										mc.nroing AS nroing,
										mc.fecmovcob AS fecmov,
										mc.nromovcob AS nromovcob,
										mc.tipdoc AS tipdoc,
										mc.id_doc AS id_doc,              
										f.numfact AS numdoc,           
										mc.codforpag AS codforpag,
										f.codmon AS codmon,
										mo.abrmon AS abrmon,
										mo.denmon AS denmon, 
										fp.denforpag AS denforpag,
										mc.conanucob AS conanucob, 
										suc.sigsuc as sigsuc,
										mc.usureg AS usureg,
										c.codcliente AS codcliente,
										uadm.sigunicosto,
										mc.obscob AS obscob,
										mc.codban AS codban,
										mc.ctaban AS ctaban,		
										(monmovcob/f.tascam) as moncobtot,
										(moncobret/f.tascam) as moncobret,
										(moncobant/f.tascam) as moncobant,
										(moncobnc/f.tascam) as moncobnc,
										(moncobotros/f.tascam) as moncobotros,
										(moncobfon/f.tascam) as moncobfon
								FROM cxc_dt_movcobro mc 
								INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
														 AND i.codsuc = mc.codsuc  
														 AND i.codcaj = mc.codcaj 
														 AND i.nroing = mc.nroing
								INNER JOIN cxc_factura f ON f.codemp = mc.codemp 
														AND f.id_fact = mc.id_doc
								LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp 
														AND suc.codsuc = f.codsuc
								LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp 
													   AND caj.codsuc = f.codsuc
													   AND caj.codcaj = f.codcaj
								LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
								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
								INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmon
								INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
								 WHERE mc.fecmovcob BETWEEN '--' AND '--'
								   AND mc.tipdoc='FACT'
								  AND  mc.codsuc IN (
													SELECT pint.codintper
													  FROM sss_permisos_internos pint
													 WHERE pint.codemp='0001' 
													   AND pint.codusu='ADMINISTRADOR' 
													   AND pint.codsis='CXC'
													   AND trim(pint.codintper)=trim(i.codsuc)
												 )
							 
								UNION ALL
								SELECT  
									    'ANU COB FACT' AS tipmov,
										c.id_cliente AS id_cliente,
										c.nombre_cliente AS nombre_cliente,
										mc.codsuc AS codsuc,
										mc.codcaj AS codcaj,
										suc.coduniejesuc AS coduniejesuc,
										mc.nroing AS nroing,
										mc.fecanucob AS fecmov,
										mc.nromovcob AS nromovcob,
										mc.tipdoc AS tipdoc,
										mc.id_doc AS id_doc,              
										f.numfact AS numdoc,           
										mc.codforpag AS codforpag,
										f.codmon AS codmon,
										mo.abrmon AS abrmon,
										mo.denmon AS denmon, 
										fp.denforpag AS denforpag,
										mc.conanucob AS conanucob,
										suc.sigsuc as sigsuc,
										mc.usureganu AS usureg,
										c.codcliente AS codcliente,
										uadm.sigunicosto,
										mc.obscob AS obscob,
										mc.codban AS codban,
										mc.ctaban AS ctaban,		
										-(monmovcob/f.tascam) as moncobtot,
										-(moncobret/f.tascam) as moncobret,
										-(moncobant/f.tascam) as moncobant,
										-(moncobnc/f.tascam) as moncobnc,
										-(moncobotros/f.tascam) as moncobotros,
										-(moncobfon/f.tascam) as moncobfon
								FROM cxc_dt_movcobro mc 
								INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
											 AND i.codsuc = mc.codsuc  
											 AND i.codcaj = mc.codcaj 
											 AND i.nroing = mc.nroing
								INNER JOIN cxc_factura f ON f.codemp = mc.codemp 
														AND f.id_fact = mc.id_doc
								LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp 
														AND suc.codsuc = f.codsuc
								LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp 
												   AND caj.codsuc = f.codsuc
												   AND caj.codcaj = f.codcaj
								LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
								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
								INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmon
								INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
								 WHERE mc.fecanucob BETWEEN '--' AND '--'
								   AND mc.estmovcob='ANU'
								   AND tipdoc='FACT'
								    AND  mc.codsuc IN (
													SELECT pint.codintper
													  FROM sss_permisos_internos pint
													 WHERE pint.codemp='0001' 
													   AND pint.codusu='ADMINISTRADOR' 
													   AND pint.codsis='CXC'
													   AND trim(pint.codintper)=trim(i.codsuc)
												 )
							 
								UNION ALL
								SELECT  
									   'COB ANT' AS tipmov,
										c.id_cliente AS id_cliente,
										c.nombre_cliente AS nombre_cliente,
										mc.codsuc AS codsuc,
										mc.codcaj AS codcaj,
										suc.coduniejesuc AS coduniejesuc,
										mc.nroing AS nroing,
										mc.fecmovcob AS fecmov,
										mc.nromovcob AS nromovcob,
										mc.tipdoc AS tipdoc,
										mc.id_doc AS id_doc,              
										a.nroant AS numdoc,           
										mc.codforpag AS codforpag,
										mc.codmon AS codmon,
										mo.abrmon AS abrmon,
										mo.denmon AS denmon, 
										fp.denforpag AS denforpag,
										mc.conanucob AS conanucob,
										suc.sigsuc as sigsuc,
										mc.usureg AS usureg,
										c.codcliente AS codcliente,
										uadm.sigunicosto,
										mc.obscob AS obscob,
										mc.codban AS codban,
										mc.ctaban AS ctaban,		
										(monmovcob/mc.tascam) as moncobtot,
										(moncobret/mc.tascam) as moncobret,
										(moncobant/mc.tascam) as moncobant,
										(moncobnc/mc.tascam) as moncobnc,
										(moncobotros/mc.tascam) as moncobotros,
										(moncobfon/mc.tascam) as moncobfon
								FROM cxc_dt_movcobro mc 
								INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
											 AND i.codsuc = mc.codsuc  
											 AND i.codcaj = mc.codcaj 
											 AND i.nroing = mc.nroing
								INNER JOIN cxc_anticipos a ON a.codemp = mc.codemp 
											  AND a.idant = mc.id_doc
								INNER JOIN cxc_clientes c ON c.id_cliente = i.id_cliente
								LEFT JOIN cxc_sucursales suc ON suc.codemp = i.codemp 
												AND suc.codsuc = i.codsuc
								LEFT JOIN cxc_cajas caj ON caj.codemp = i.codemp 
											   AND caj.codsuc = i.codsuc
											AND caj.codcaj = i.codcaj
								LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc			
								INNER JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
								INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmon
								INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
								 WHERE  mc.fecmovcob BETWEEN '--' AND '--'
								    AND mc.tipdoc='ANTI'
								    AND  mc.codsuc IN (
													SELECT pint.codintper
													  FROM sss_permisos_internos pint
													 WHERE pint.codemp='0001' 
													   AND pint.codusu='ADMINISTRADOR' 
													   AND pint.codsis='CXC'
													   AND trim(pint.codintper)=trim(i.codsuc)
												 )
							 
								UNION ALL
								SELECT  
									    'ANU COB ANT' AS tipmov,
										c.id_cliente AS id_cliente,
										c.nombre_cliente AS nombre_cliente,
										mc.codsuc AS codsuc,
										mc.codcaj AS codcaj,
										suc.coduniejesuc AS coduniejesuc,
										mc.nroing AS nroing,
										mc.fecanucob AS fecmov,
										mc.nromovcob AS nromovcob,
										mc.tipdoc AS tipdoc,
										mc.id_doc AS id_doc,              
										a.nroant AS numdoc,           
										mc.codforpag AS codforpag,
										mc.codmon AS codmon,
										mo.abrmon AS abrmon,
										mo.denmon AS denmon, 
										fp.denforpag AS denforpag,
										mc.conanucob AS conanucob,
										suc.sigsuc as sigsuc,
										mc.usureganu AS usureg,
										c.codcliente AS codcliente,
										uadm.sigunicosto,
										mc.obscob AS obscob,
										mc.codban AS codban,
										mc.ctaban AS ctaban,		
										-(monmovcob/mc.tascam) as moncobtot,
										-(moncobret/mc.tascam) as moncobret,
										-(moncobant/mc.tascam) as moncobant,
										-(moncobnc/mc.tascam) as moncobnc,
										-(moncobotros/mc.tascam) as moncobotros,
										-(moncobfon/mc.tascam) as moncobfon
								FROM cxc_dt_movcobro mc 
								INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
											 AND i.codsuc = mc.codsuc  
											 AND i.codcaj = mc.codcaj 
											 AND i.nroing = mc.nroing
								INNER JOIN cxc_anticipos a ON a.codemp = mc.codemp 
											  AND a.idant = mc.id_doc
								INNER JOIN cxc_clientes c ON c.id_cliente = i.id_cliente
								LEFT JOIN cxc_sucursales suc ON suc.codemp = i.codemp 
												AND suc.codsuc = i.codsuc
								LEFT JOIN cxc_cajas caj ON caj.codemp = i.codemp 
											   AND caj.codsuc = i.codsuc
											AND caj.codcaj = i.codcaj
								LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
								INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmon
								INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
								 WHERE  mc.fecanucob BETWEEN '--' AND '--'
								   AND mc.tipdoc='ANTI'
								   AND mc.estmovcob='ANU'
								    AND  mc.codsuc IN (
													SELECT pint.codintper
													  FROM sss_permisos_internos pint
													 WHERE pint.codemp='0001' 
													   AND pint.codusu='ADMINISTRADOR' 
													   AND pint.codsis='CXC'
													   AND trim(pint.codintper)=trim(i.codsuc)
												 )
							 
								ORDER BY 14,8,4,5,7
							

29/08/2021 17:02:26  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cxc_c_reportes <br><b>METODO:</b> ConsultaFacturacionNetaAero <br><b>ERROR-></b><br>Invalid query: ERROR:  syntax error at or near "AS"
LINE 3:                AS intervalo,
                       ^
Whole query:  	
							SELECT codmon,
							        AS intervalo,
								   sum(serv) AS serv,
								   sum(prod) AS prod,
								   sum(iva) AS iva,
								   sum(tasas) as tasas,  
								   (sum(serv)+sum(prod)+sum(iva)+sum(tasas)) AS fac_bruta   
							FROM
							(
							
									SELECT f.codmon,
										   sum((f.subtotservi)/f.tascam) AS serv,
										   sum((f.subtotprod)/f.tascam) AS prod,
										   sum((f.subtotconce)/f.tascam) AS tasas,
										   sum((f.iva)/f.tascam) AS iva		       	  
									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 
									  AND f.id_estfact!=7									  
									   AND f.codmon = 'AWG' 
									GROUP BY 1	
									UNION
									SELECT f.codmon,
										   -sum((d.subtotservidoc)/d.tascam_doc) AS serv,
										   -sum((d.subtotproddoc)/d.tascam_doc) AS prod,
										   -sum((d.subtotconcedoc)/d.tascam_doc) AS tasas,
										   -sum((d.iva_doc)/d.tascam_doc) AS iva
									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
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									 WHERE d.fecdoc BETWEEN 
									   AND d.codtipdoc='NC'
									   AND estdoccxc!='A'									  
									    AND f.codmon = 'AWG' 
									GROUP BY 1
									UNION
									SELECT f.codmon,
										   sum((d.subtotservidoc)/d.tascam_doc) AS serv,
										   sum((d.subtotproddoc)/d.tascam_doc) AS prod,
										   sum((d.subtotconcedoc)/d.tascam_doc) AS tasas,
										   sum((d.iva_doc)/d.tascam_doc) AS iva
									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
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									 WHERE d.fecdoc BETWEEN 
									   AND d.codtipdoc='ND'
									   AND estdoccxc!='A'									  
									    AND f.codmon = 'AWG' 
									GROUP BY 1
									
							) AS venta
							GROUP BY 1
					  

29/08/2021 17:08:08  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cxc_c_reportes <br><b>METODO:</b> ConsultaFacturacionNetaAero <br><b>ERROR-></b><br>Invalid query: ERROR:  syntax error at or near "AS"
LINE 3:                AS intervalo,
                       ^
Whole query:  	
							SELECT codmon,
							        AS intervalo,
								   sum(serv) AS serv,
								   sum(prod) AS prod,
								   sum(iva) AS iva,
								   sum(tasas) as tasas,  
								   (sum(serv)+sum(prod)+sum(iva)+sum(tasas)) AS fac_bruta   
							FROM
							(
							
									SELECT f.codmon,
										   sum((f.subtotservi)/f.tascam) AS serv,
										   sum((f.subtotprod)/f.tascam) AS prod,
										   sum((f.subtotconce)/f.tascam) AS tasas,
										   sum((f.iva)/f.tascam) AS iva		       	  
									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 
									  AND f.id_estfact!=7									  
									   AND f.codmon = 'CUC' 
									GROUP BY 1	
									UNION
									SELECT f.codmon,
										   -sum((d.subtotservidoc)/d.tascam_doc) AS serv,
										   -sum((d.subtotproddoc)/d.tascam_doc) AS prod,
										   -sum((d.subtotconcedoc)/d.tascam_doc) AS tasas,
										   -sum((d.iva_doc)/d.tascam_doc) AS iva
									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
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									 WHERE d.fecdoc BETWEEN 
									   AND d.codtipdoc='NC'
									   AND estdoccxc!='A'									  
									    AND f.codmon = 'CUC' 
									GROUP BY 1
									UNION
									SELECT f.codmon,
										   sum((d.subtotservidoc)/d.tascam_doc) AS serv,
										   sum((d.subtotproddoc)/d.tascam_doc) AS prod,
										   sum((d.subtotconcedoc)/d.tascam_doc) AS tasas,
										   sum((d.iva_doc)/d.tascam_doc) AS iva
									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
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									 WHERE d.fecdoc BETWEEN 
									   AND d.codtipdoc='ND'
									   AND estdoccxc!='A'									  
									    AND f.codmon = 'CUC' 
									GROUP BY 1
									
							) AS venta
							GROUP BY 1
					  

29/08/2021 17:10:24  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cxc_c_reportes <br><b>METODO:</b> ConsultaFacturacionNetaAero <br><b>ERROR-></b><br>Invalid query: ERROR:  column "enero" does not exist
LINE 3:               enero AS intervalo,
                      ^
Whole query:  	
							SELECT codmon,
							       enero AS intervalo,
								   sum(serv) AS serv,
								   sum(prod) AS prod,
								   sum(iva) AS iva,
								   sum(tasas) as tasas,  
								   (sum(serv)+sum(prod)+sum(iva)+sum(tasas)) AS fac_bruta   
							FROM
							(
							
									SELECT f.codmon,
										   sum((f.subtotservi)/f.tascam) AS serv,
										   sum((f.subtotprod)/f.tascam) AS prod,
										   sum((f.subtotconce)/f.tascam) AS tasas,
										   sum((f.iva)/f.tascam) AS iva		       	  
									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-01-01' AND '2021-01-31'
									  AND f.id_estfact!=7									  
									   AND f.codmon = 'CUC' 
									GROUP BY 1	
									UNION
									SELECT f.codmon,
										   -sum((d.subtotservidoc)/d.tascam_doc) AS serv,
										   -sum((d.subtotproddoc)/d.tascam_doc) AS prod,
										   -sum((d.subtotconcedoc)/d.tascam_doc) AS tasas,
										   -sum((d.iva_doc)/d.tascam_doc) AS iva
									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
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									 WHERE d.fecdoc BETWEEN '2021-01-01' AND '2021-01-31'
									   AND d.codtipdoc='NC'
									   AND estdoccxc!='A'									  
									    AND f.codmon = 'CUC' 
									GROUP BY 1
									UNION
									SELECT f.codmon,
										   sum((d.subtotservidoc)/d.tascam_doc) AS serv,
										   sum((d.subtotproddoc)/d.tascam_doc) AS prod,
										   sum((d.subtotconcedoc)/d.tascam_doc) AS tasas,
										   sum((d.iva_doc)/d.tascam_doc) AS iva
									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
									LEFT JOIN covensol_tipo_operacion_negocio ton ON ton.tipopeneg = f.tipopeneg
									 WHERE d.fecdoc BETWEEN '2021-01-01' AND '2021-01-31'
									   AND d.codtipdoc='ND'
									   AND estdoccxc!='A'									  
									    AND f.codmon = 'CUC' 
									GROUP BY 1
									
							) AS venta
							GROUP BY 1