Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012017Openbravo ERP09. Financial managementpublic2010-01-20 13:172010-03-12 22:41
Reporternetworkb 
Assigned Tobalamurugan 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP10 
Target Version2.50MP14Fixed in Version2.50MP14 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012017: Error in Payment Report
DescriptionIE.
If we have some payment in USD, the report makes no change of currency.
Steps To Reproduce-As Openbravo Admin go to General Setup || Application || Currency
-Select USD and go to Conversion Rates.
-Create a new record:
   -To currency: EUR.
   -Valid from Date: 19-01-2010
   -Divide Rate by: 2
-Save and go to EUR and Conversion Rates:
-Create a new record,
   -To currency: USD.
   -Valid from Date: 19-01-2010
   -Multiple Rate by: 2

-Save and go to Master Data Management || Pricing || Price List
-Select Purchase and change the currency to USD.
-Save and go to Procurement Management || Transactions || Purchase Invoice
-Create a new record:
   -Bussines Partner: McGiver.
-Save and go to Lines.
   -Product: Hammer
   -Unit Price: 1000.
-Save, go to the Header, complete and post.

-Go to Financial Management || Receivables & Payables || Analysis Tools || Payment Report
   -Business Partners: McGiver
   -To Date: 29-01-2010
-Click HTML format
-Realize that there is a line with currency USD and amount 1000
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 00021812.50 closed rafaroda Currency in reports - non accounting reports 
Attached Filespng Payment_Report.png (155,686) 2010-02-25 09:59
https://issues.openbravo.com/file_download.php?file_id=2280&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2010-01-20 13:17networkbNew Issue
2010-01-20 13:17networkbAssigned To => rafaroda
2010-02-08 12:46rafarodaNote Added: 0024010
2010-02-08 12:46rafarodaAssigned Torafaroda => dalsasua
2010-02-08 12:46rafarodaPriorityimmediate => high
2010-02-08 12:46rafarodaRelationship addedrelated to 0002181
2010-02-23 05:54balamuruganAssigned Todalsasua => balamurugan
2010-02-23 10:27dalsasuaPriorityhigh => urgent
2010-02-25 09:56dalsasuaNote Added: 0024807
2010-02-25 09:56dalsasuaStatusnew => feedback
2010-02-25 09:59dalsasuaFile Added: Payment_Report.png
2010-02-25 11:57dalsasuaNote Edited: 0024807bug_revision_view_page.php?bugnote_id=0024807#r73
2010-03-01 12:44networkbNote Added: 0024901
2010-03-01 12:44networkbStatusfeedback => new
2010-03-08 11:14hgbotCheckin
2010-03-08 11:14hgbotNote Added: 0025115
2010-03-08 11:14hgbotStatusnew => resolved
2010-03-08 11:14hgbotResolutionopen => fixed
2010-03-08 11:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ea3c2d1c6e7d96591c43fcafa4631712cd866f22 [^]
2010-03-08 16:05jpabloaeTarget Version2.50MP13 => 2.50MP14
2010-03-09 07:11arunkumarNote Added: 0025156
2010-03-09 07:11arunkumarStatusresolved => closed
2010-03-09 07:11arunkumarFixed in Version => 2.50MP13
2010-03-10 17:21anonymoussf_bug_id0 =>
2010-03-10 18:29anonymoussf_bug_id => 2967988
2010-03-11 10:29jpabloaeFixed in Version2.50MP13 => 2.50MP14
2010-03-12 22:41hudsonbotCheckin
2010-03-12 22:41hudsonbotNote Added: 0025402

Notes
(0024010)
rafaroda   
2010-02-08 12:46   
David,

Can you please take action on this issue?

Thanks.
(0024807)
dalsasua   
2010-02-25 09:56   
(edited on: 2010-02-25 11:57)
Having payments of different currencies is ok: a payment can have a currency different from the one in the system, and this correct. What is not correct is to add different currencies in the total amount (see attachment).
Reporter must provide a proposed solution, as for example, to have a currency combo in the filters section of the report, and provide totals converted to that currency, using the document date to convert, like in Sales Management || Analysis Tools || Sales Dimensional Report || Sales Dimensional Report.
(0024901)
networkb   
2010-03-01 12:44   
Sure. Please implement this logic
(0025115)
hgbot   
2010-03-08 11:14   
Repository: erp/devel/pi
Changeset: ea3c2d1c6e7d96591c43fcafa4631712cd866f22
Author: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com>
Date: Mon Mar 08 15:48:23 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/ea3c2d1c6e7d96591c43fcafa4631712cd866f22 [^]

Fixes Issue 12017: Error in Payment Report.

---
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.html
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.java
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
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_data.xsql
---
(0025156)
arunkumar   
2010-03-09 07:11   
Tested & Working fine
(0025402)
hudsonbot   
2010-03-12 22:41   
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/ea3c2d1c6e7d [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]