Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0029605Openbravo ERP09. Financial managementpublic2015-04-15 18:492016-02-02 09:34
malsasua 
aferraz 
immediatemajoralways
closedfixed 
20Community Appliance
 
 
vmromanos
Core
Production - Confirmed Stable
2014-09-23
3.0PR14Q4
https://code.openbravo.com/erp/devel/pi/rev/179d97ee602d [^]
No
0029605: foreign currency and foreign amount are not assigned in transaction
when a transaction is created manually (with "new" button and "process" button), the foreign currency and foreign amount is not assigned, and error is returned when transaction is posted
. in F&B
. price list window:
 Otros Servicios
 . change currency from EUR to USD

. financial account window:
 Cuenta de Banco -> Payment Method -> transferencia
  . Make Payments in Multiple Currency -> select
  . automatic drawals -> unselect

. purchase invoice window:
 new record:
  . org: F&B España SA
  . bp: Generación Eléctrica
 . new line:
  product: electricidad
  qty: 100
process it
(invoice currency: USD)
Add Details
 .paid it and not reconcile:
    "Action Regarding Document" -> Pocess Made Payments

go to fincial account "Cuenta de Banco"
 . new transaction: select the above payment
 . process it
 . post it: error is returned:
Process failed during execution

No tags attached.
depends on backport 00296333.0PR15Q2 closed aferraz foreign currency and foreign amount are not assigned in transaction 
depends on backport 00296343.0PR15Q1.4 closed aferraz foreign currency and foreign amount are not assigned in transaction 
caused by feature request 0029387 closed Sandrahuguet Transaction refactor project 
? 29605.sql (493) 2015-05-18 12:50
https://issues.openbravo.com/file_download.php?file_id=8098&type=bug
Issue History
2015-04-15 18:49malsasuaNew Issue
2015-04-15 18:49malsasuaAssigned To => Triage Finance
2015-04-15 18:49malsasuaModules => Core
2015-04-15 18:49malsasuaTriggers an Emergency Pack => No
2015-04-17 10:12maiteIssue Monitored: networkb
2015-04-17 14:07aferrazRelationship addedcaused by 0029387
2015-04-17 14:08aferrazRegression level => Production - QA Approved
2015-04-17 14:08aferrazRegression date => 2014-09-23
2015-04-17 14:08aferrazRegression introduced in release => 3.0PR14Q4
2015-04-17 14:08aferrazRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/179d97ee602d [^]
2015-04-17 14:51aferrazPriorityhigh => immediate
2015-04-20 10:27aferrazNote Added: 0076622
2015-04-20 10:31aferrazStatusnew => scheduled
2015-04-20 10:31aferrazAssigned ToTriage Finance => aferraz
2015-04-20 11:49jonalegriaesarteResolution time => 1431640800
2015-04-21 13:10aferrazRegression levelProduction - QA Approved => Production - Confirmed Stable
2015-04-21 13:52hgbotCheckin
2015-04-21 13:52hgbotNote Added: 0076658
2015-04-21 13:52hgbotStatusscheduled => resolved
2015-04-21 13:52hgbotResolutionopen => fixed
2015-04-21 13:52hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7f6f8501e7628ca753738013cfc0641093e2a5d2 [^]
2015-04-21 13:52vmromanosReview Assigned To => vmromanos
2015-04-21 13:52vmromanosNote Added: 0076659
2015-04-21 13:52vmromanosStatusresolved => closed
2015-05-07 22:16hudsonbotCheckin
2015-05-07 22:16hudsonbotNote Added: 0077139
2015-05-18 12:50aferrazFile Added: 29605.sql
2015-05-18 12:51aferrazNote Added: 0077527
2016-02-02 09:34hgbotCheckin
2016-02-02 09:34hgbotNote Added: 0083802

Notes
(0076622)
aferraz   
2015-04-20 10:27   
Test plan:

In F&B:
. price list window:
 Otros Servicios
 . change currency from EUR to USD

. financial account window:
 Cuenta de Banco -> Payment Method -> transferencia
  . Make Payments in Multiple Currency -> select
  . automatic drawals -> unselect

. purchase invoice window:
 new record:
  . org: F&B España SA
  . bp: Generación Eléctrica
 . new line:
  product: electricidad
  qty: 100
process it
(invoice currency: USD)
Add Details
 .paid it and not reconcile:
    "Action Regarding Document" -> Pocess Made Payments

go to fincial account "Cuenta de Banco"
 . new transaction: select the above payment
 . process it
 . post it

Realize transaction is posted correctly
(0076658)
hgbot   
2015-04-21 13:52   
Repository: erp/devel/pi
Changeset: 7f6f8501e7628ca753738013cfc0641093e2a5d2
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Apr 21 11:04:04 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7f6f8501e7628ca753738013cfc0641093e2a5d2 [^]

Fixes issue 29605: Foreign currency not setted in transaction

When creating a transaction manually from a payment, foreign currency, foreign conversion rate and foreign amount fields were not setted to transaction. Now, they will be setted as in TransactionDao.java, when the transaction is automatically created from the payment.

---
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_TransactionProcess.java
---
(0076659)
vmromanos   
2015-04-21 13:52   
Code review + testing OK
(0077139)
hudsonbot   
2015-05-07 22:16   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/a1817f84bd8b [^]
Maturity status: Test
(0077527)
aferraz   
2015-05-18 12:51   
Attached a query to fix wrong data created by the issue
(0083802)
hgbot   
2016-02-02 09:34   
Repository: tools/automation/int
Changeset: 50555365e65c4d4edc7cd50cb4488c154d6c14b5
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri Sep 18 18:56:43 2015 +0200
URL: http://code.openbravo.com/tools/automation/int/rev/50555365e65c4d4edc7cd50cb4488c154d6c14b5 [^]

Related to issue 29605: Added some automated tests

---
M src-test/com/openbravo/test/integration/erp/data/financial/receivablespayables/transactions/financialaccount/TransactionsData.java
M src-test/com/openbravo/test/integration/erp/modules/functionalteam/addpayment/testsuites/APR_Regressions/RegressionSuite.java
M src-test/com/openbravo/test/integration/erp/modules/functionalteam/addpayment/testsuites/APR_Regressions/build.xml
A src-test/com/openbravo/test/integration/erp/modules/functionalteam/addpayment/testsuites/APR_Regressions/APRRegression012.java
A src-test/com/openbravo/test/integration/erp/modules/functionalteam/addpayment/testsuites/APR_Regressions/APRRegression013.java
---