Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024748Openbravo ERPZ. Otherspublic2013-09-12 10:292013-10-30 09:06
ReporterdaniOpenbravo 
Assigned Topramakrishnan 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP26.2 
Target Version3.0MP29Fixed in Version3.0MP29 
Merge Request Status
Review Assigned Toegoitz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket23348
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024748: Purchase invoice dimensional report does not take correct conversion rate.
DescriptionWhen customer creates a purchase invoice, he can select the exchange rate for that invoice. The problem is that purchase invoice dimensional report takes the conversion rate according to the corresponding value (depending on the date) in conversion rates of the currency window and it only should be in this way when there is no exchange rate defined in purchase invoice window.
As a result of this issue, invoice´s total amount is not correct in the report.

Note: Take a look at sales invoice and sales invoice dimensional report too.
Steps To Reproduce- Create purchase invoice and define a exchange rate.
- Complete invoice.
- Post invoice: it takes the value defined on the invoice.
- Open Purchase invoice dimensional Report and select created invoice: realize that total amount is not correct because conversion rate applied is not the invoice´s one.
Proposed SolutionPurchase invoice dimensional report should take at first exchange rates defined in purchase invoices and if there is no one, then it should select the corresponding one according to the date of the invoice (conversion rate window).
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-09-12 10:29daniOpenbravoNew Issue
2013-09-12 10:29daniOpenbravoAssigned To => dmiguelez
2013-09-12 10:29daniOpenbravoModules => Core
2013-09-12 10:29daniOpenbravoOBNetwork customer => Yes
2013-09-12 10:29daniOpenbravoSupport ticket => 23348
2013-09-12 10:29daniOpenbravoTriggers an Emergency Pack => No
2013-09-16 13:22jonalegriaesarteTarget Version3.0MP28 => 3.0MP29
2013-09-18 12:09dmiguelezAssigned Todmiguelez => jonalegriaesarte
2013-10-03 10:18jonalegriaesarteAssigned Tojonalegriaesarte => pramakrishnan
2013-10-17 09:28pramakrishnanReview Assigned To => jonalegriaesarte
2013-10-17 09:28pramakrishnanStatusnew => scheduled
2013-10-17 09:30hgbotCheckin
2013-10-17 09:30hgbotNote Added: 0061763
2013-10-17 09:30hgbotStatusscheduled => resolved
2013-10-17 09:30hgbotResolutionopen => fixed
2013-10-17 09:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/05fe91911ed7e36443a2b1ab4defb2764e3b3ea9 [^]
2013-10-17 18:21hudsonbotCheckin
2013-10-17 18:21hudsonbotNote Added: 0061779
2013-10-30 09:06egoitzReview Assigned Tojonalegriaesarte => egoitz
2013-10-30 09:06egoitzNote Added: 0061957
2013-10-30 09:06egoitzStatusresolved => closed
2013-10-30 09:06egoitzFixed in Version => 3.0MP29

Notes
(0061763)
hgbot   
2013-10-17 09:30   
Repository: erp/devel/pi
Changeset: 05fe91911ed7e36443a2b1ab4defb2764e3b3ea9
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Wed Oct 16 19:25:48 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/05fe91911ed7e36443a2b1ab4defb2764e3b3ea9 [^]

Fixes Issue 24748: Wrong conversion rate in Purchase invoice dimensional report

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR_data.xsql
---
(0061779)
hudsonbot   
2013-10-17 18:21   
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/121b38a3673a [^]

Maturity status: Test
(0061957)
egoitz   
2013-10-30 09:06   
verified