18/09/2021 16:07:39  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> VALIDACIÓN DE DATOS: Faltan la datos de la moneda para configurar la conversión

18/09/2021 16:26:45  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> consulta_documentosInvalid query: ERROR:  column f.estdoccxc does not exist
LINE 129: ...T JOIN cxc_estatus_documento es ON es.estdoccxc = f.estdoccx...
                                                               ^
HINT:  Perhaps you meant to reference the column "es.estdoccxc".
Whole query: SELECT   doc.*,f.*, c.*, es.*, v.nomvend, v.codvend, codtransp, desctransp, denmon, abrmon, desccondpago, 
								tc.tipo_cliente, tc.tipo_cliente,ctlcontauto,tc.aplautodoc,
					            descestfact, desest,denmun,denpar,cp.operacion as opespi,cp.diascred as diascredito,doc.codsuc as codsuc_doc,doc.codcaj as codcaj_doc,
								suc.nomsuc,suc.sucmatriz,caj.nomcaj,caj.scg_cuenta as scg_caja,caj.estcaj,suc.sigsuc,suc.codseriesuc,suc.enablescgunieje,suc.coduniejesuc,
								c.sc_cuenta as scg_cliente,
								'('||succl.codsuccli||') - '||succl.nomsuccli AS descsuccli,
								(
									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, 
								(
									doc.total_doc
									-
									( SELECT COALESCE(sum(monmovdoc),0) 
									  FROM cxc_dt_movdoc dmd 
									  WHERE dmd.codtipdoc=doc.codtipdoc 
									  AND dmd.id_doc=doc.id_doc
									  AND tipdocapl='FACT'
									  AND estmovdoc!='ANU'
									 )
							
								) AS saldo_credito,
								( SELECT COALESCE(sum(monmovdoc),0) 
									  FROM cxc_dt_movdoc dmd 
									  WHERE dmd.codtipdoc=doc.codtipdoc 
									  AND dmd.id_doc=doc.id_doc
									  AND tipdocapl='FACT'
									  AND estmovdoc!='ANU'
							
								) AS total_aplicado, 
								(
									
									CASE WHEN doc.codtipdoc = 'NC' THEN (
																			SELECT DISTINCT scg.comprobante 
																				  FROM cxc_dt_scg scg
																				 WHERE scg.tipdoc = doc.codtipdoc
																				   AND procede = 'CXCCRE'
																				   AND scg.id_doc = doc.id_doc
																				LIMIT 1
																		)
										WHEN doc.codtipdoc = 'ND' THEN (
																			SELECT DISTINCT scg.comprobante 
																				  FROM cxc_dt_scg scg
																				 WHERE scg.tipdoc = doc.codtipdoc
																				   AND procede = 'CXCDEB'
																				   AND scg.id_doc = doc.id_doc
																				LIMIT 1
																		) 
										ELSE ''
									END  
								
								) AS nrocmpscg
								
								  FROM cxc_documento doc  INNER JOIN cxc_factura f ON doc.id_fact = f.id_fact
					                  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_documento es ON es.estdoccxc = f.estdoccxc
									  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
									  LEFT JOIN cxc_clientes cdoc ON cdoc.id_cliente = f.id_cliente_doc
									  LEFT JOIN cxc_sucursales_clientes succl ON succl.id_cliente = f.id_cliente
																		     AND succl.codsuccli = f.codsuccli
									  WHERE doc.codemp = '0001' 
									     
									    AND doc.id_doc='3'

18/09/2021 16:26:59  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> consulta_documentosInvalid query: ERROR:  column "descestfact" does not exist
LINE 3:                  descestfact, desest,denmun,denpar,cp.operac...
                         ^
HINT:  Perhaps you meant to reference the column "f.descripfact".
Whole query: SELECT   doc.*,f.*, c.*, es.*, v.nomvend, v.codvend, codtransp, desctransp, denmon, abrmon, desccondpago, 
								tc.tipo_cliente, tc.tipo_cliente,ctlcontauto,tc.aplautodoc,
					            descestfact, desest,denmun,denpar,cp.operacion as opespi,cp.diascred as diascredito,doc.codsuc as codsuc_doc,doc.codcaj as codcaj_doc,
								suc.nomsuc,suc.sucmatriz,caj.nomcaj,caj.scg_cuenta as scg_caja,caj.estcaj,suc.sigsuc,suc.codseriesuc,suc.enablescgunieje,suc.coduniejesuc,
								c.sc_cuenta as scg_cliente,
								'('||succl.codsuccli||') - '||succl.nomsuccli AS descsuccli,
								(
									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, 
								(
									doc.total_doc
									-
									( SELECT COALESCE(sum(monmovdoc),0) 
									  FROM cxc_dt_movdoc dmd 
									  WHERE dmd.codtipdoc=doc.codtipdoc 
									  AND dmd.id_doc=doc.id_doc
									  AND tipdocapl='FACT'
									  AND estmovdoc!='ANU'
									 )
							
								) AS saldo_credito,
								( SELECT COALESCE(sum(monmovdoc),0) 
									  FROM cxc_dt_movdoc dmd 
									  WHERE dmd.codtipdoc=doc.codtipdoc 
									  AND dmd.id_doc=doc.id_doc
									  AND tipdocapl='FACT'
									  AND estmovdoc!='ANU'
							
								) AS total_aplicado, 
								(
									
									CASE WHEN doc.codtipdoc = 'NC' THEN (
																			SELECT DISTINCT scg.comprobante 
																				  FROM cxc_dt_scg scg
																				 WHERE scg.tipdoc = doc.codtipdoc
																				   AND procede = 'CXCCRE'
																				   AND scg.id_doc = doc.id_doc
																				LIMIT 1
																		)
										WHEN doc.codtipdoc = 'ND' THEN (
																			SELECT DISTINCT scg.comprobante 
																				  FROM cxc_dt_scg scg
																				 WHERE scg.tipdoc = doc.codtipdoc
																				   AND procede = 'CXCDEB'
																				   AND scg.id_doc = doc.id_doc
																				LIMIT 1
																		) 
										ELSE ''
									END  
								
								) AS nrocmpscg
								
								  FROM cxc_documento doc  INNER JOIN cxc_factura f ON doc.id_fact = f.id_fact
					                  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_documento es ON es.estdoccxc = doc.estdoccxc
									  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
									  LEFT JOIN cxc_clientes cdoc ON cdoc.id_cliente = f.id_cliente_doc
									  LEFT JOIN cxc_sucursales_clientes succl ON succl.id_cliente = f.id_cliente
																		     AND succl.codsuccli = f.codsuccli
									  WHERE doc.codemp = '0001' 
									     
									    AND doc.id_doc='3'

18/09/2021 16:27:58  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> consulta_documentosInvalid query: ERROR:  column es.estdoccxc does not exist
LINE 130: ...         LEFT JOIN cxc_estatus_documento esdoc ON es.estdocc...
                                                               ^
HINT:  Perhaps you meant to reference the column "doc.estdoccxc" or the column "esdoc.estdoccxc".
Whole query: SELECT   doc.*,f.*, c.*, esdoc.*, v.nomvend, v.codvend, codtransp, desctransp, denmon, abrmon, desccondpago, 
								tc.tipo_cliente, tc.tipo_cliente,ctlcontauto,tc.aplautodoc,
					            descestfact, desest,denmun,denpar,cp.operacion as opespi,cp.diascred as diascredito,doc.codsuc as codsuc_doc,doc.codcaj as codcaj_doc,
								suc.nomsuc,suc.sucmatriz,caj.nomcaj,caj.scg_cuenta as scg_caja,caj.estcaj,suc.sigsuc,suc.codseriesuc,suc.enablescgunieje,suc.coduniejesuc,
								c.sc_cuenta as scg_cliente,
								'('||succl.codsuccli||') - '||succl.nomsuccli AS descsuccli,
								(
									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, 
								(
									doc.total_doc
									-
									( SELECT COALESCE(sum(monmovdoc),0) 
									  FROM cxc_dt_movdoc dmd 
									  WHERE dmd.codtipdoc=doc.codtipdoc 
									  AND dmd.id_doc=doc.id_doc
									  AND tipdocapl='FACT'
									  AND estmovdoc!='ANU'
									 )
							
								) AS saldo_credito,
								( SELECT COALESCE(sum(monmovdoc),0) 
									  FROM cxc_dt_movdoc dmd 
									  WHERE dmd.codtipdoc=doc.codtipdoc 
									  AND dmd.id_doc=doc.id_doc
									  AND tipdocapl='FACT'
									  AND estmovdoc!='ANU'
							
								) AS total_aplicado, 
								(
									
									CASE WHEN doc.codtipdoc = 'NC' THEN (
																			SELECT DISTINCT scg.comprobante 
																				  FROM cxc_dt_scg scg
																				 WHERE scg.tipdoc = doc.codtipdoc
																				   AND procede = 'CXCCRE'
																				   AND scg.id_doc = doc.id_doc
																				LIMIT 1
																		)
										WHEN doc.codtipdoc = 'ND' THEN (
																			SELECT DISTINCT scg.comprobante 
																				  FROM cxc_dt_scg scg
																				 WHERE scg.tipdoc = doc.codtipdoc
																				   AND procede = 'CXCDEB'
																				   AND scg.id_doc = doc.id_doc
																				LIMIT 1
																		) 
										ELSE ''
									END  
								
								) AS nrocmpscg
								
								  FROM cxc_documento doc  INNER JOIN cxc_factura f ON doc.id_fact = f.id_fact
					                  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_estatus_documento esdoc ON es.estdoccxc = doc.estdoccxc
									  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
									  LEFT JOIN cxc_clientes cdoc ON cdoc.id_cliente = f.id_cliente_doc
									  LEFT JOIN cxc_sucursales_clientes succl ON succl.id_cliente = f.id_cliente
																		     AND succl.codsuccli = f.codsuccli
									  WHERE doc.codemp = '0001' 
									     
									    AND doc.id_doc='3'