ADempiere ERP Business Suite / Discussion / Language-Spanish: Cheque Asiento Contable

Lay Joseph Lopez - 2014-06-13

Estimados:

Estoy haciendo el cheque con ireport ya lo pude generar de la tabla c_payment
ahora quiero mostrar el asiento contable que genera , lo he buscado en facct_acct, pero no logro
relacionarlo, me gustaria que me dieran una pista como relacionar el cheque con el asiento contable

Saludos

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Victor Porras - 2014-06-13
  
  relacionado de esta forma:
  
  from c_payselection_check_v cpsc
  join c_payment p on cpsc.c_payment_id = p.c_payment_id
  join fact_acct f on p.c_payment_id = f.record_id
  
  Saludos,
  
  Víctor Hugo Porras Orozco
  Informático, Nicaragua
  
  Por lo tanto, dado que tenemos estas promesas,
  amados, limpiémonos de toda contaminación de la carne y del espíritu,
  perfeccionando la santidad en el temor de Dios.
  
  2 Corintios 7:1
  
  To: 623063@discussion.adempiere.p.re.sf.net
  From: layjoseph@users.sf.net
  Subject: [adempiere:discussion] Cheque Asiento Contable
  Date: Fri, 13 Jun 2014 15:19:28 +0000
  
  Estimados:
  
  Estoy haciendo el cheque con ireport ya lo pude generar de la tabla c_payment
  
  ahora quiero mostrar el asiento contable que genera , lo he buscado en facct_acct, pero no logro
  
  relacionarlo, me gustaria que me dieran una pista como relacionar el cheque con el asiento contable
  
  Saludos
  
  Cheque Asiento Contable
  
  Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/adempiere/discussion/623063/
  
  To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Lay Joseph Lopez - 2014-06-13

Estimado victor:

hice lo siguiente:

select f.record_id,p.c_payment_id,cpsc.c_payselection_id,f.ad_client_id,f.account_id,f.amtacctdr,f.amtacctcr
from c_payselection_check_v cpsc
inner join c_payment p on cpsc.c_payselection_id = p.c_payment_id inner join fact_acct f on p.c_payment_id = f.record_id
Where p.c_payment_id=1000001

Resultado:

1000001 1000001 1000001 1000000 1004404 1770 0
1000001 1000001 1000001 1000000 1000080 0 1770
1000001 1000001 1000001 1000000 1004404 1739.15 0
1000001 1000001 1000001 1000000 1000080 0 1739.15
1000001 1000001 1000001 1000000 1000080 1739.15 0
1000001 1000001 1000001 1000000 1004404 0 1739.15
1000001 1000001 1000001 1000000 1004404 0 1770
1000001 1000001 1000001 1000000 1004404 1770 0
1000001 1000001 1000001 1000000 1004404 0 1739.15
1000001 1000001 1000001 1000000 1004404 1739.15 0
1000001 1000001 1000001 1000000 1005528 755.35 0
1000001 1000001 1000001 1000000 1004404 1495.65 0
1000001 1000001 1000001 1000000 1004404 3540 0
1000001 1000001 1000001 1000000 1004913 0 5791
1000001 1000001 1000001 1000000 1004913 5791 0
1000001 1000001 1000001 1000000 1006212 0 5791
1000001 1000001 1000001 1000000 1006212 5791 0
1000001 1000001 1000001 1000000 1000040 0 5791
1000001 1000001 1000001 1000000 1000040 0 5791
1000001 1000001 1000001 1000000 1000040 5791 0
1000001 1000001 1000001 1000000 1000040 0 4035.52
1000001 1000001 1000001 1000000 1000040 4035.52 0

El valor Del Cheque Es de 5,791.00

Tu Ayuda Por Favor:

Solo Quiero Que me aparezca COMO EN LA VENTAS PAGOS/COBROS

Cuenta Débito Contabilizado
203-0058-000 - PAGOS SIN ASIGNAR 5,791.00
111-0001-000 - BANCO ATLANTIDA No. 2-10000517-8 5,791.00

APROVECHANDO EL ESPACIO POR QUE SIEMPRE QUE HAGO UN CHEQUE ME LO CARGA A PAGOS SIN ASIGNAR

SALUDOS Y MUCHAS GRACIAS

DIOS TE BENDIGA

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Victor Porras - 2014-06-14
  
  Proba con este código:
  selectb.c_bank_id as id_banco,b.name as banco,ba.c_bankaccount_id as id_cuenta_banco,ba.accountno as cuenta_banco,p.c_payment_id as id_pago,p.documentno as num_cheque,p.datetrx as fecha_contable,extract(day from p.datetrx) as dia,extract(MONTH from p.datetrx) as mes,extract(year from p.datetrx) as año,bp.c_bpartner_id as id_beneficiario,bp.value as cod_beneficiario,p.a_name as otro,case when p.a_name isnull then upper(poner_asteriscos(bp.name)) else upper(poner_asteriscos(p.a_name)) end as beneficiario,p.description as concepto,p.c_currency_id as id_moneda,cu.cursymbol as moneda,asteriscos_numeros(cast(cast(p.payamt as numeric(10,2)) as varchar)) as monto,upper(poner_asteriscos(f_convnl(cast(trunc(p.payamt) as numeric(10,2))) || ' ' || cu.description || ' con ' ||f_convnl(cast((p.payamt-trunc(p.payamt))*100 as numeric(10,2))) || ' ' || 'Centavos')) as monto_letra,ev.c_elementvalue_id as id_cuenta,ev.value as cod_cuenta,ev.name as cuenta,f.amtacctdr as debito,f.amtacctcr as creditofrom c_payselection_check_v cpscjoin c_payment p on cpsc.c_payment_id = p.c_payment_idjoin c_bankaccount ba on p.c_bankaccount_id = ba.c_bankaccount_idjoin c_bank b on ba.c_bank_id = b.c_bank_idjoin c_bpartner bp on p.c_bpartner_id = bp.c_bpartner_idjoin c_doctype dt on p.c_doctype_id = dt.c_doctype_idjoin fact_acct f on p.c_payment_id = f.record_idjoin ad_table t on f.ad_table_id = t.ad_table_idjoin c_elementvalue ev on f.account_id = ev.c_elementvalue_idjoin c_currency_trl cu on p.c_currency_id = cu.c_currency_id and cu.ad_language = 'es_NI'where p.ad_client_id = 1000000and p.docstatus = 'CO'and dt.c_doctype_id = 1000009and t.tablename = 'C_Payment'and cpsc.c_payselectioncheck_id = 1000838 --$P{RECORD_ID} Parametro del Id de Pagoand f.record_id = cpsc.c_payment_id ;
  Saludos,
  
  Víctor Hugo Porras Orozco
  Informático, Nicaragua
  
  To: 623063@discussion.adempiere.p.re.sf.net
  From: layjoseph@users.sf.net
  Subject: [adempiere:discussion] Cheque Asiento Contable
  Date: Fri, 13 Jun 2014 23:45:37 +0000
  
  Estimado victor:
  
  hice lo siguiente:
  
  select f.record_id,p.c_payment_id,cpsc.c_payselection_id,f.ad_client_id,f.account_id,f.amtacctdr,f.amtacctcr
  
  from c_payselection_check_v cpsc
  
  inner join c_payment p on cpsc.c_payselection_id = p.c_payment_id inner join fact_acct f on p.c_payment_id = f.record_id
  
  Where p.c_payment_id=1000001
  
  Resultado:
  
  1000001 1000001 1000001 1000000 1004404 1770 0
  
  1000001 1000001 1000001 1000000 1000080 0 1770
  
  1000001 1000001 1000001 1000000 1004404 1739.15 0
  
  1000001 1000001 1000001 1000000 1000080 0 1739.15
  
  1000001 1000001 1000001 1000000 1000080 1739.15 0
  
  1000001 1000001 1000001 1000000 1004404 0 1739.15
  
  1000001 1000001 1000001 1000000 1004404 0 1770
  
  1000001 1000001 1000001 1000000 1004404 1770 0
  
  1000001 1000001 1000001 1000000 1004404 0 1739.15
  
  1000001 1000001 1000001 1000000 1004404 1739.15 0
  
  1000001 1000001 1000001 1000000 1005528 755.35 0
  
  1000001 1000001 1000001 1000000 1004404 1495.65 0
  
  1000001 1000001 1000001 1000000 1004404 3540 0
  
  1000001 1000001 1000001 1000000 1004913 0 5791
  
  1000001 1000001 1000001 1000000 1004913 5791 0
  
  1000001 1000001 1000001 1000000 1006212 0 5791
  
  1000001 1000001 1000001 1000000 1006212 5791 0
  
  1000001 1000001 1000001 1000000 1000040 0 5791
  
  1000001 1000001 1000001 1000000 1000040 0 5791
  
  1000001 1000001 1000001 1000000 1000040 5791 0
  
  1000001 1000001 1000001 1000000 1000040 0 4035.52
  
  1000001 1000001 1000001 1000000 1000040 4035.52 0
  
  El valor Del Cheque Es de 5,791.00
  
  Tu Ayuda Por Favor:
  
  Solo Quiero Que me aparezca COMO EN LA VENTAS PAGOS/COBROS
  
  Cuenta Débito Contabilizado
  
  203-0058-000 - PAGOS SIN ASIGNAR 5,791.00
  
  111-0001-000 - BANCO ATLANTIDA No. 2-10000517-8 5,791.00
  
  APROVECHANDO EL ESPACIO POR QUE SIEMPRE QUE HAGO UN CHEQUE ME LO CARGA A PAGOS SIN ASIGNAR
  
  SALUDOS Y MUCHAS GRACIAS
  
  DIOS TE BENDIGA
  
  Cheque Asiento Contable
  
  Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/adempiere/discussion/623063/
  
  To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Lay Joseph Lopez - 2014-06-16

Gracias Victor Si funciono le quite unas funciones que llamas y me salio lo siguiente:

1000000 Banco atlantida S.A. 1000000 2-10000517-8 1000001 125002 2014-06-11 00:00:00 11 6 2014 1000003 1000000 LUBRIN PAGO FACTURA 1250001 272 L 5791.00 5791.00 LEMPIRA CON 0.00 CENTAVOS 1000040 111-0001-000 BANCO ATLANTIDA No. 2-10000517-8 0 5791
1000000 Banco atlantida S.A. 1000000 2-10000517-8 1000001 125002 2014-06-11 00:00:00 11 6 2014 1000003 1000000 LUBRIN PAGO FACTURA 1250001 272 L 5791.00 5791.00 LEMPIRA CON 0.00 CENTAVOS 1006212 203-0058-000 PAGOS SIN ASIGNAR 5791 0

CUANDO PUEDAS ME SACAS DE LA DUDA POR QUE SI HAGO UN PAGO A PROVEEDORES ME LO TIRA A LA CUENTA PAGOS SIN ASIGNAR, EN VEZ DEL PROVEEDOR, QUE AL FINAL CUANDO ME VOY AL AUXILIAR SIEMPRE REBAJA LA FACTURA. TE CUENTO QUE LA FACTURA LA ESTOY PAGANDO ANTES DE LA FECHA DE VENCIMIENTO SERA POR ESO.

COMO HAGO PARA QUE NO ME LO TIRE A PAGOS SIN ASIGNAR

SALUDOS

DIOS TE BENDIGA

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Cheque Asiento Contable

A full ERP system - moved to GitHub. See full description for details.

Forums

Help

Cheque Asiento Contable

Cheque Asiento Contable

A full ERP system - moved to GitHub. See full description for details.

Forums

Help

Cheque Asiento Contable document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

Cheque Asiento Contable