Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007305Openbravo ERP03. Procurement managementpublic2009-01-30 15:352009-05-11 11:27
Reportervillind 
Assigned Torafaroda 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP1 
Target VersionFixed in Version2.40MP4 
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
Summary0007305: Procurement reports do not handle currencies
DescriptionAll reports in procurement management ignore the currency.
Steps To Reproduce1. Create purchase order, invoice and material receipt using foreign currency
2. Run reports -> amounts are displayed in foreign currency
Proposed SolutionDisplay amounts using the currency defined for the client.
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0007396 closed gorkaion Purchase Order Report is not filtering by Client and Organization 
depends on backport 0007480 closed rafaroda SQL error badly informed when printing Jasper Report 
depends on backport 0007577 closed shuehner Improve messaging where there is no conversion rate 
depends on backport 0007956 closed rafaroda Sales Reports do not handle currencies 
depends on backport 0007957 closed rafaroda Multi currency issues in some processes and tables 
blocks defect 0007272 closed rafaroda Procurement reports do not handle currencies 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-02 09:11rafarodaTypedefect => backport
2009-02-02 09:11rafarodafix_in_branch => 2.40
2009-02-03 12:03rafarodaNote Added: 0013073
2009-02-03 14:56rafarodaNote Edited: 0013073
2009-02-05 15:51rafarodaRelationship addeddepends on 0007396
2009-02-05 15:56rafarodaNote Added: 0013188
2009-02-10 12:58rafarodaRelationship addeddepends on 0007480
2009-02-16 13:42rafarodaRelationship addeddepends on 0007577
2009-02-16 13:50rafarodaNote Added: 0013533
2009-03-05 09:18rafarodaRelationship addeddepends on 0007956
2009-03-05 09:24rafarodaRelationship addeddepends on 0007957
2009-03-05 09:26rafarodaNote Added: 0014417
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015322
2009-04-11 12:35hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/135c5f78925e2c27cf080dbfe87fb94623083f13 [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015323
2009-04-11 12:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/135c5f78925e2c27cf080dbfe87fb94623083f13 [^] => http://code.openbravo.com/erp/stable/2.40/rev/90b596457a2efd5debfbccbb0c78fe255fd4f7d2 [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015324
2009-04-11 12:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/90b596457a2efd5debfbccbb0c78fe255fd4f7d2 [^] => http://code.openbravo.com/erp/stable/2.40/rev/eb5967a23ab179183c7ec80e2cbc22c9d82c1ffc [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015325
2009-04-11 12:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/eb5967a23ab179183c7ec80e2cbc22c9d82c1ffc [^] => http://code.openbravo.com/erp/stable/2.40/rev/31fda3e2f61f69337b7155de9da4179bcd14c52e [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015326
2009-04-11 12:35hgbotStatusscheduled => resolved
2009-04-11 12:35hgbotResolutionopen => fixed
2009-04-11 12:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/31fda3e2f61f69337b7155de9da4179bcd14c52e [^] => http://code.openbravo.com/erp/stable/2.40/rev/78ce1ea2d3a2cba5a706384ad21950a537821aea [^]
2009-05-10 19:37psarobeFixed in Version => 2.40MP4
2009-05-11 11:27sureshbabuStatusresolved => closed
2009-05-11 11:27sureshbabuNote Added: 0016250

Notes
(0013073)
rafaroda   
2009-02-03 12:03   
(edited on: 2009-02-03 14:56)
The following reports will be addressed: http://wiki.openbravo.com/wiki/Projects/Multi_Currency_Reports_Review/Development_Status#Procurement_Management [^]

* Procurement/Analysis tools/Purchase Dimensional Report
* Procurement/Analysis tools/Material Receipts Dimensional Report
* Procurement/Analysis tools/Purchase Invoice Dimensional Report
* Procurement/Analysis tools/Purchase Order Report
* Procurement/Analysis tools/Vendor Invoice Report
(0013188)
rafaroda   
2009-02-05 15:56   
* Procurement/Analysis tools/Purchase Dimensional Report
* Procurement/Analysis tools/Material Receipts Dimensional Report
* Procurement/Analysis tools/Purchase Invoice Dimensional Report
* Procurement/Analysis tools/Vendor Invoice Report


Are already implemented. Waiting for resolving some issues in Purchase Order Report to commit the entire fix.
(0013533)
rafaroda   
2009-02-16 13:50   
All procurement reports are now multi-currency in Openbravo 2.40. Waiting for backport 7577 [1] resolution to commit the final solution.

Sorry for the inconveniences.

[1] https://issues.openbravo.com/view.php?id=7577 [^]
(0014417)
rafaroda   
2009-03-05 09:26   
All reports within Openbravo ERP 2.40 will be reviewed to support multi-currency. This issue keeps idle until 0007957 and 0007956 are resolved.

Sorry for the inconveniences.
(0015322)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: 135c5f78925e2c27cf080dbfe87fb94623083f13
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Wed Mar 18 11:38:38 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/135c5f78925e2c27cf080dbfe87fb94623083f13 [^]

Issue 0007305 Purchase Order Report

---
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
M src/org/openbravo/erpCommon/ad_reports/ReportPurchaseOrder.jrxml
---
(0015323)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: 90b596457a2efd5debfbccbb0c78fe255fd4f7d2
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Wed Mar 18 11:47:29 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/90b596457a2efd5debfbccbb0c78fe255fd4f7d2 [^]

Issue 0007305 Vendor Invoice Report

---
M src/org/openbravo/erpCommon/ad_reports/InvoiceEdition_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorFilterJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorFilterJR.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorJR.jrxml
---
(0015324)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: eb5967a23ab179183c7ec80e2cbc22c9d82c1ffc
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Wed Mar 18 11:55:29 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/eb5967a23ab179183c7ec80e2cbc22c9d82c1ffc [^]

Issue 0007305 Purchase Invoice Dimensional Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesFilterJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesFilterJR.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR_data.xsql
M src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalComparative.jrxml
M src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalNoComparative.jrxml
---
(0015325)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: 31fda3e2f61f69337b7155de9da4179bcd14c52e
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Wed Mar 18 11:57:40 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/31fda3e2f61f69337b7155de9da4179bcd14c52e [^]

Issue 0007305 Material Receipts Dimensional Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesFilterJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesFilterJR.xml
M src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesJR_data.xsql
---
(0015326)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: 78ce1ea2d3a2cba5a706384ad21950a537821aea
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Wed Mar 18 12:00:24 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/78ce1ea2d3a2cba5a706384ad21950a537821aea [^]

Fixes bug 0007305 Purchase Dimensional Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesFilterJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesFilterJR.xml
M src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR_data.xsql
---
(0016250)
sureshbabu   
2009-05-11 11:27   
Tested working fine