Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012936Openbravo ERP09. Financial managementpublic2010-04-12 12:252010-05-18 21:44
Reporternetworkb 
Assigned Tobalamurugan 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP14 
Target Version2.50MP17Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012936: The Payment Report does not show the original currency and the original amount
DescriptionThe payment report shows the amount with the system's currency (I.E. EUR)but it does not show the amount with the original currency (USD)

To reproduce it you must have an efect with currency: USD
Steps To Reproduce- As Openbravo Admin go to Financial Management || Receivables & Payables || Analysis Tools || Payment Report
    - Currency EUR.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-04-12 12:25networkbNew Issue
2010-04-12 12:25networkbAssigned To => dalsasua
2010-04-12 12:25networkbOBNetwork customer => Yes
2010-04-26 19:50dalsasuaStatusnew => scheduled
2010-04-26 19:50dalsasuaNote Added: 0026700
2010-04-26 19:50dalsasuaAssigned Todalsasua => balamurugan
2010-04-26 19:50dalsasuafix_in_branch => pi
2010-05-11 11:19balamuruganNote Added: 0027129
2010-05-11 11:19balamuruganAssigned Tobalamurugan => networkb
2010-05-11 11:20balamuruganNote Added: 0027130
2010-05-11 11:20balamuruganStatusscheduled => feedback
2010-05-11 14:04networkbNote Added: 0027138
2010-05-11 14:04networkbStatusfeedback => new
2010-05-11 14:04networkbfix_in_branchpi =>
2010-05-11 15:52networkbAssigned Tonetworkb => balamurugan
2010-05-11 18:19jpabloaeTarget Version2.50MP16 => 2.50MP17
2010-05-13 16:28adrianromeroStatusnew => scheduled
2010-05-13 16:28adrianromerofix_in_branch => pi
2010-05-14 18:14hgbotCheckin
2010-05-14 18:14hgbotNote Added: 0027317
2010-05-14 18:14hgbotStatusscheduled => resolved
2010-05-14 18:14hgbotResolutionopen => fixed
2010-05-14 18:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d58960feb659b7bf368b775061fc817b23ceba32 [^]
2010-05-15 16:30sureshbabuNote Added: 0027326
2010-05-15 16:31sureshbabuNote Added: 0027327
2010-05-15 16:31sureshbabuStatusresolved => closed
2010-05-15 19:28hgbotCheckin
2010-05-15 19:28hgbotNote Added: 0027335
2010-05-15 19:28hgbotStatusclosed => resolved
2010-05-15 19:28hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/d58960feb659b7bf368b775061fc817b23ceba32 [^] => http://code.openbravo.com/erp/devel/pi/rev/0727e9ac504705d0c3dad50939cc1d01b5ff48aa [^]
2010-05-17 08:02sureshbabuNote Added: 0027346
2010-05-17 08:02sureshbabuStatusresolved => closed
2010-05-18 00:00anonymoussf_bug_id0 => 3002951
2010-05-18 21:44hudsonbotCheckin
2010-05-18 21:44hudsonbotNote Added: 0027533
2010-05-18 21:44hudsonbotCheckin
2010-05-18 21:44hudsonbotNote Added: 0027535

Notes
(0026700)
dalsasua   
2010-04-26 19:50   
Planned to be fixed by May, 11th
(0027129)
balamurugan   
2010-05-11 11:19   
This is not an issue, since in Payment Report window, new dropdown box is provided to filter the report based on the currency, so it converts the amount based on the selected currency.(related to issue 12017)
https://issues.openbravo.com/view.php?id=12017. [^]
(0027130)
balamurugan   
2010-05-11 11:20   
This is not an issue, since in Payment Report window, new dropdown box is provided to filter the report based on the currency, so it converts the amount based on the selected currency.(related to issue 12017)
https://issues.openbravo.com/view.php?id=12017 [^]
(0027138)
networkb   
2010-05-11 14:04   
It is not possible to see the original currency and te original amount. On payment report, if you choose EUR you can not see on payment the original currency (USD).

the solution could be to add a column where it appears the original amount and the original currency.
(0027317)
hgbot   
2010-05-14 18:14   
Repository: erp/devel/pi
Changeset: d58960feb659b7bf368b775061fc817b23ceba32
Author: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com>
Date: Fri May 14 21:43:10 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/d58960feb659b7bf368b775061fc817b23ceba32 [^]

Fixes Issue 12936: The Payment Report does not show original currency and amount

---
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.html
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.xml
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_BankAcc.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_NoBP.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_NoBP_BankAcc.jrxml
---
(0027326)
sureshbabu   
2010-05-15 16:30   
1) created conversion rate for both USD to EUR and EUR to USD
2) Changed the currency of the price list(Sales) to USD,
3) Created sales invoice using the above updated price list for amount 67.28, while completing the invoice a new payment document is created (PM1)
4) The above payment (PM1) is received through bank statement.
5) Then i run the payment report after selecting the currency as USD and after required filter options then i can able to view the original amount of 67.28 and original currency of USD in the report
(0027327)
sureshbabu   
2010-05-15 16:31   
verified. i used the steps which i have updated in the notes to make sure whether the issue is rightly fixed
(0027335)
hgbot   
2010-05-15 19:28   
Repository: erp/devel/pi
Changeset: 0727e9ac504705d0c3dad50939cc1d01b5ff48aa
Author: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com>
Date: Sat May 15 22:56:43 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/0727e9ac504705d0c3dad50939cc1d01b5ff48aa [^]

Fixes Issue 12936: Build Break Fixed.

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
---
(0027346)
sureshbabu   
2010-05-17 08:02   
Once again verified the issue in oracle context
(0027533)
hudsonbot   
2010-05-18 21:44   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/d58960feb659 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/aa11838d5f80 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17380.obx [^]
(0027535)
hudsonbot   
2010-05-18 21:44   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/0727e9ac5047 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/aa11838d5f80 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17380.obx [^]