Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0012017
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2010-01-20 13:172010-03-12 22:41
ReporternetworkbView Statuspublic 
Assigned Tobalamurugan 
PriorityurgentResolutionfixedFixed in Version2.50MP14
StatusclosedFix in branchFixed in SCM revisionea3c2d1c6e7d
ProjectionnoneETAnoneTarget Version2.50MP14
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP10SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012017: 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
TagsNo tags attached.
Attached Filespng file icon Payment_Report.png [^] (155,686 bytes) 2010-02-25 09:59

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 00021812.50 closedrafaroda Currency in reports - non accounting reports 

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

 David,

Can you please take action on this issue?

Thanks.
(0024807)
dalsasua (reporter)
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 (developer)
2010-03-01 12:44

 Sure. Please implement this logic
(0025115)
hgbot (developer)
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 (reporter)
2010-03-09 07:11

 Tested & Working fine
(0025402)
hudsonbot (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2010-01-20 13:17 networkb New Issue
2010-01-20 13:17 networkb Assigned To => rafaroda
2010-02-08 12:46 rafaroda Note Added: 0024010
2010-02-08 12:46 rafaroda Assigned To rafaroda => dalsasua
2010-02-08 12:46 rafaroda Priority immediate => high
2010-02-08 12:46 rafaroda Relationship added related to 0002181
2010-02-23 05:54 balamurugan Assigned To dalsasua => balamurugan
2010-02-23 10:27 dalsasua Priority high => urgent
2010-02-25 09:56 dalsasua Note Added: 0024807
2010-02-25 09:56 dalsasua Status new => feedback
2010-02-25 09:59 dalsasua File Added: Payment_Report.png
2010-02-25 11:57 dalsasua Note Edited: 0024807 View Revisions
2010-03-01 12:44 networkb Note Added: 0024901
2010-03-01 12:44 networkb Status feedback => new
2010-03-08 11:14 hgbot Checkin
2010-03-08 11:14 hgbot Note Added: 0025115
2010-03-08 11:14 hgbot Status new => resolved
2010-03-08 11:14 hgbot Resolution open => fixed
2010-03-08 11:14 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ea3c2d1c6e7d96591c43fcafa4631712cd866f22 [^]
2010-03-08 16:05 jpabloae Target Version 2.50MP13 => 2.50MP14
2010-03-09 07:11 arunkumar Note Added: 0025156
2010-03-09 07:11 arunkumar Status resolved => closed
2010-03-09 07:11 arunkumar Fixed in Version => 2.50MP13
2010-03-10 17:21 anonymous sf_bug_id 0 =>
2010-03-10 18:29 anonymous sf_bug_id => 2967988
2010-03-11 10:29 jpabloae Fixed in Version 2.50MP13 => 2.50MP14
2010-03-12 22:41 hudsonbot Checkin
2010-03-12 22:41 hudsonbot Note Added: 0025402

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker