17/04/2015 08:29:59  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_scc_c_cajachica <br><b>METODO:</b> insert_recepcion_documento <br><b>ERROR-></b><br>Invalid query: ERROR:  error de sintaxis en o cerca de «,»
LINE 5: ...'2015-04-17','2015-04-17','2015-04-17',15000.00,0,,'B','SCC-...
                                                             ^
Whole query: INSERT INTO cxp_rd (codemp,numrecdoc,codtipdoc,ced_bene,cod_pro,dencondoc,fecemidoc, fecregdoc, fecvendoc,
 		                            montotdoc, mondeddoc,moncardoc,tipproben,numref,estprodoc,procede,estlibcom,estaprord,
				                    fecaprord,usuaprord,estimpmun,codcla,codfuefin,codrecdoc,repcajchi)
				     VALUES ('0001','SCC-APR00000001','00001','010112978',
				             '----------','APERTURA DE CAJA CHICA: CAJA PRESIDENCIA','2015-04-17','2015-04-17','2015-04-17',15000.00,0,,'B','SCC-APR00000001','R','SCCAPR',0,0,'1900-01-01','ADMINISTRADOR',0,'--','--','000000000000359',0)

17/04/2015 08:32:42  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_scc_c_cajachica <br><b>METODO:</b> insert_recepcion_documento <br><b>ERROR-></b><br>Invalid query: ERROR:  error de sintaxis en o cerca de «,»
LINE 5: ...'2015-04-17','2015-04-17','2015-04-17',15000.00,0,,'B','SCC-...
                                                             ^
Whole query: INSERT INTO cxp_rd (codemp,numrecdoc,codtipdoc,ced_bene,cod_pro,dencondoc,fecemidoc, fecregdoc, fecvendoc,
 		                            montotdoc, mondeddoc,moncardoc,tipproben,numref,estprodoc,procede,estlibcom,estaprord,
				                    fecaprord,usuaprord,estimpmun,codcla,codfuefin,codrecdoc,repcajchi)
				     VALUES ('0001','SCC-APR00000001','00001','010112978',
				             '----------','APERTURA DE CAJA CHICA: CAJA PRESIDENCIA','2015-04-17','2015-04-17','2015-04-17',15000.00,0,,'B','SCC-APR00000001','R','SCCAPR',0,0,'1900-01-01','ADMINISTRADOR',0,'--','--','000000000000359',0)

17/04/2015 11:13:39  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> consulta_facturasInvalid query: ERROR:  la referencia a la columna «nomvend» es ambigua
LINE 103:             AND nomvend ILIKE('%DENNY%')                   
                          ^
Whole query: SELECT   f.*, c.*, v.nomvend, v.codvend, codtransp, desctransp, denmon, abrmon, desccondpago, cp.diascred as diascredito, 
					            descestfact,cp.operacion as opespi,
					            suc.nomsuc,suc.sucmatriz,caj.nomcaj,caj.scg_cuenta as scg_caja,caj.estcaj,suc.sigsuc,
								(now()::date - f.fecfact) as diasemifact, 
								cp.diascred as diascredfact, 
							    (CASE WHEN (cp.diascred - (now()::date - f.fecfact)::integer)::integer<0 AND f.id_estfact!=4 AND cp.operacion='DEV'  
									   THEN abs((cp.diascred - (now()::date - f.fecfact)::integer)::integer)
								 ELSE 0
								 END) as diasvencfact,
								 (
									SELECT COALESCE(SUM(doc.total_doc),0) 
									  FROM cxc_documento doc 
									 WHERE doc.id_fact = f.id_fact
									   AND codtipdoc = 'NC'
									   AND anulado_doc = '0'	       
								) AS total_cre,
								(
									SELECT COALESCE(SUM(doc.total_doc),0) 
									  FROM cxc_documento doc 
									 WHERE doc.id_fact = f.id_fact
									   AND codtipdoc = 'ND'
									   AND anulado_doc = '0'	       
								) AS total_deb,
								(
									  f.total 
									  -
									  ( SELECT COALESCE(SUM(doc.total_doc),0) 
										  FROM cxc_documento doc 
										 WHERE doc.id_fact = f.id_fact
										   AND codtipdoc = 'NC'
										   AND anulado_doc = '0'
									   )
									   + 
									   (
										SELECT COALESCE(SUM(doc.total_doc),0) 
										  FROM cxc_documento doc 
										 WHERE doc.id_fact = f.id_fact
										   AND codtipdoc = 'ND'
										   AND anulado_doc = '0'	       
									   ) 
								) AS total_act,
								(
									  f.subtot 
									  -
									  ( SELECT COALESCE(SUM(doc.subtot_doc),0) 
										  FROM cxc_documento doc 
										 WHERE doc.id_fact = f.id_fact
										   AND codtipdoc = 'NC'
										   AND anulado_doc = '0' 
									   )
									   + 
									   (
										SELECT COALESCE(SUM(doc.subtot_doc),0) 
										  FROM cxc_documento doc 
										 WHERE doc.id_fact = f.id_fact
										   AND codtipdoc = 'ND'
										   AND anulado_doc = '0'	       
									   ) 
								) AS subtot_act,
								(
									  f.iva 
									  -
									  ( SELECT COALESCE(SUM(doc.iva_doc),0) 
										  FROM cxc_documento doc 
										 WHERE doc.id_fact = f.id_fact
										   AND codtipdoc = 'NC'
										   AND anulado_doc = '0' 
									   )
									   + 
									   (
										SELECT COALESCE(SUM(doc.iva_doc),0) 
										  FROM cxc_documento doc 
										 WHERE doc.id_fact = f.id_fact
										   AND codtipdoc = 'ND'
										   AND anulado_doc = '0'	       
									   ) 
								) AS iva_act
							   FROM cxc_factura f 
									  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 cxc_clientes c ON c.id_cliente = f.id_cliente
									  LEFT JOIN cxc_vendedores v ON v.id_vend = f.id_vend
									  LEFT JOIN cxc_transporte t ON t.id_transp = f.id_transp
									  LEFT JOIN sigesp_moneda mo ON f.codmon = mo.codmon
									  LEFT JOIN cxc_condiciones_pago cp ON cp.id_condpago = f.id_condpago
									  LEFT JOIN cxc_estatus_factura es ON es.id_estfact = f.id_estfact
									  LEFT JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
									  LEFT JOIN cxc_zonas z ON z.id_zona = c.id_zona
									  LEFT JOIN cxc_clasif_clientes cc ON cc.id_clasif_cliente = c.id_clasif_cliente
									  LEFT JOIN cxc_vendedores vc ON vc.id_vend = c.id_vend
									  LEFT JOIN scg_cuentas cu ON cu.codemp = c.codemp AND cu.sc_cuenta = c.sc_cuenta AND status='C'
									  LEFT JOIN sigesp_pais p ON p.codpai = c.codpai
									  LEFT JOIN sigesp_estados e ON e.codpai = c.codpai AND e.codest = c.codest 
									  LEFT JOIN sigesp_municipio m ON m.codpai = c.codpai AND m.codest = c.codest AND m.codmun = c.codmun
									  LEFT JOIN sigesp_parroquia pa ON pa.codpai = c.codpai AND pa.codest = c.codest AND pa.codmun = c.codmun AND pa.codpar = c.codpar
									  WHERE f.codemp = '0001'
									    AND f.codproceso='FACTURA' 
									    AND f.descripfact ILIKE('%%')	
									    AND f.comentadifact ILIKE('%%')	
									   AND nomvend ILIKE('%DENNY%') 							  								 
									  ORDER BY f.numfact