Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007956Openbravo ERP07. Sales managementpublic2009-03-05 09:152009-05-11 11:22
Reporternetworkb 
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
Summary0007956: Sales Reports do not handle currencies
DescriptionSales reports in Openbravo ERP ignore the currency.
Steps To Reproduce1. Create sales 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.

Reports addressed:
* Sales Management/Analysis tools/Sales Dimensional Report
* Sales Management/Analysis tools/Shipments Dimensional Report
* Sales Management/Analysis tools/Discount Invoice Report
* Sales Management/Analysis tools/Sales Order Returns Dimensional Report
* Sales Management/Analysis tools/Sales Order Report
* Sales Management/Analysis tools/Invoiced Sales Order Report
* Sales Management/Analysis tools/Orders Awaiting Invoice Report
* Sales Management/Analysis tools/Delivered Sales Order Report
* Sales Management/Analysis tools/Invoice Detail
* Sales Management/Analysis tools/Customer Invoice Report
* Sales Management/Analysis tools/Sales Invoice Dimensional Report
* Sales Management/Analysis tools/Sales Report by Partner and Product
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0007957 closed rafaroda Multi currency issues in some processes and tables 
related to backport 0008541 closed rafaroda Warehouse Reports do not handle currencies 
related to backport 0008543 closed rafaroda Production Reports do not handle currencies 
related to backport 0008545 closed rafaroda Projects Reports do not handle currencies 
blocks defect 0007955 closed rafaroda Sales Reports do not handle currencies 
blocks backport 0007305 closed rafaroda Procurement reports do not handle currencies 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-03-05 09:16rafarodaTypedefect => backport
2009-03-05 09:16rafarodafix_in_branch => 2.40
2009-03-05 09:18rafarodaRelationship addedblocks 0007305
2009-03-05 09:22rafarodaRelationship addeddepends on 0007957
2009-03-05 09:26rafarodaSteps to Reproduce Updated
2009-04-11 11:55rafarodaSummaryReports do not handle currencies => Sales Reports do not handle currencies
2009-04-11 11:55rafarodaDescription Updated
2009-04-11 11:55rafarodaSteps to Reproduce Updated
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015327
2009-04-11 12:35hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/16f5c3b103d23bfd0224fcac8b374e852bce4362 [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015328
2009-04-11 12:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/16f5c3b103d23bfd0224fcac8b374e852bce4362 [^] => http://code.openbravo.com/erp/stable/2.40/rev/224cd114cec47ee0ae74efe4c3ba858f20b61a2a [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015329
2009-04-11 12:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/224cd114cec47ee0ae74efe4c3ba858f20b61a2a [^] => http://code.openbravo.com/erp/stable/2.40/rev/3b4c86f41532aef99d7255d6bf23da515650e860 [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015330
2009-04-11 12:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/3b4c86f41532aef99d7255d6bf23da515650e860 [^] => http://code.openbravo.com/erp/stable/2.40/rev/2049ddb02c5a8fe8a7d214a62563952a7747217b [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015331
2009-04-11 12:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/2049ddb02c5a8fe8a7d214a62563952a7747217b [^] => http://code.openbravo.com/erp/stable/2.40/rev/aed98d367f22566bfec581a27342b1fa94a06e49 [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015332
2009-04-11 12:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/aed98d367f22566bfec581a27342b1fa94a06e49 [^] => http://code.openbravo.com/erp/stable/2.40/rev/5a4227ba53f018888d1255325a556360e32c783e [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015333
2009-04-11 12:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/5a4227ba53f018888d1255325a556360e32c783e [^] => http://code.openbravo.com/erp/stable/2.40/rev/432da3a14b065a90d4821777a9036f585de534ec [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015334
2009-04-11 12:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/432da3a14b065a90d4821777a9036f585de534ec [^] => http://code.openbravo.com/erp/stable/2.40/rev/7c00d218d646694eb1a69d5d00d915e415f4fefd [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015335
2009-04-11 12:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/7c00d218d646694eb1a69d5d00d915e415f4fefd [^] => http://code.openbravo.com/erp/stable/2.40/rev/5e9aec8d8a9b759cb65e9b577edf6fab67c173ee [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015336
2009-04-11 12:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/5e9aec8d8a9b759cb65e9b577edf6fab67c173ee [^] => http://code.openbravo.com/erp/stable/2.40/rev/49ba7ff153440febf774a24ccadbb1c801c32636 [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015337
2009-04-11 12:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/49ba7ff153440febf774a24ccadbb1c801c32636 [^] => http://code.openbravo.com/erp/stable/2.40/rev/553f41adc4904d67ada989a5828347223e3d2371 [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015338
2009-04-11 12:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/553f41adc4904d67ada989a5828347223e3d2371 [^] => http://code.openbravo.com/erp/stable/2.40/rev/eb4ed70872b88b2d3e7104c186d1af0b195d2ed9 [^]
2009-04-11 12:35hgbotCheckin
2009-04-11 12:35hgbotNote Added: 0015339
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/eb4ed70872b88b2d3e7104c186d1af0b195d2ed9 [^] => http://code.openbravo.com/erp/stable/2.40/rev/9f8225563b7842804929b4732a756a6dd659d204 [^]
2009-04-11 12:45rafarodaRelationship addedrelated to 0008541
2009-04-11 12:46rafarodaRelationship addedrelated to 0008543
2009-04-11 12:49rafarodaRelationship addedrelated to 0008545
2009-05-10 19:37psarobeFixed in Version => 2.40MP4
2009-05-11 11:22sureshbabuStatusresolved => closed
2009-05-11 11:22sureshbabuNote Added: 0016248

Notes
(0015327)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: 16f5c3b103d23bfd0224fcac8b374e852bce4362
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Fri Apr 10 09:29:53 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/16f5c3b103d23bfd0224fcac8b374e852bce4362 [^]

Issue 0007956 Sales Dimensional Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJRFilter.html
M src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJRFilter.xml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR_data.xsql
M src/org/openbravo/erpCommon/ad_reports/WeightDimensionalComparative.jrxml
M src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml
---
(0015328)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: 224cd114cec47ee0ae74efe4c3ba858f20b61a2a
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Fri Apr 10 10:00:39 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/224cd114cec47ee0ae74efe4c3ba858f20b61a2a [^]

Issue 0007956 Shipments Dimensional Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJRFilter.html
M src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJRFilter.xml
M src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJR_data.xsql
---
(0015329)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: 3b4c86f41532aef99d7255d6bf23da515650e860
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Fri Apr 10 10:47:55 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/3b4c86f41532aef99d7255d6bf23da515650e860 [^]

Issue 0007956 Discount Invoice Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscount.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscount_data.xsql
---
(0015330)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: 2049ddb02c5a8fe8a7d214a62563952a7747217b
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Fri Apr 10 13:12:18 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/2049ddb02c5a8fe8a7d214a62563952a7747217b [^]

Issue 0007956 Sales Order Report

---
M src/org/openbravo/erpCommon/ad_reports/OrderEdition_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderFilterJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderFilterJR.xml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderJR.jrxml
---
(0015331)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: aed98d367f22566bfec581a27342b1fa94a06e49
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Fri Apr 10 15:07:32 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/aed98d367f22566bfec581a27342b1fa94a06e49 [^]

Issue 0007956 Invoiced Sales Order Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoicedJasper.html
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoicedJasper.java
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoicedJasper.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoicedJasper.xml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoiced_data.xsql
---
(0015332)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: 5a4227ba53f018888d1255325a556360e32c783e
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Fri Apr 10 15:27:30 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/5a4227ba53f018888d1255325a556360e32c783e [^]

Issue 0007956 Orders Awaiting Invoice Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceFilterJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceFilterJR.xml
M src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoice_data.xsql
---
(0015333)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: 432da3a14b065a90d4821777a9036f585de534ec
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Fri Apr 10 15:46:31 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/432da3a14b065a90d4821777a9036f585de534ec [^]

Issue 0007956 Delivered Sales Order Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.xml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvided_data.xsql
---
(0015334)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: 7c00d218d646694eb1a69d5d00d915e415f4fefd
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Fri Apr 10 16:08:18 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/7c00d218d646694eb1a69d5d00d915e415f4fefd [^]

Issue 0007956 Invoice Detail

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoices.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoicesEditJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoicesJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportInvoicesJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoicesJR.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoices_data.xsql
---
(0015335)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: 5e9aec8d8a9b759cb65e9b577edf6fab67c173ee
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Fri Apr 10 16:56:32 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/5e9aec8d8a9b759cb65e9b577edf6fab67c173ee [^]

Issue 0007956 Customer Invoice Report

---
M src/org/openbravo/erpCommon/ad_reports/InvoiceCustomerEdition_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerEdition.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerFilterJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerFilterJR.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerJR.jrxml
---
(0015336)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: 49ba7ff153440febf774a24ccadbb1c801c32636
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Fri Apr 10 17:42:12 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/49ba7ff153440febf774a24ccadbb1c801c32636 [^]

Issue 0007956 Sales Invoice Dimensional Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJRFilter.html
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJRFilter.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml
---
(0015337)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: 553f41adc4904d67ada989a5828347223e3d2371
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Fri Apr 10 19:08:43 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/553f41adc4904d67ada989a5828347223e3d2371 [^]

Issue 0007956 Sales Order Returns Dimensional Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalyses.fo
M src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalyses.java
M src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalysesEdition.html
M src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalysesEdition.xml
M src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalysesEditionPDF.xml
M src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalysesFilter.html
M src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalysesFilter.xml
M src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalysesPDF.java
M src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalyses_data.xsql
M src/org/openbravo/erpCommon/utility/Utility.java
M src/org/openbravo/erpCommon/utility/Utility_data.xsql
---
(0015338)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: eb4ed70872b88b2d3e7104c186d1af0b195d2ed9
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Sat Apr 11 11:52:33 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/eb4ed70872b88b2d3e7104c186d1af0b195d2ed9 [^]

Issue 0007956 Sales Report by Partner and Product

---
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesPartnerProduct.jrxml
---
(0015339)
hgbot   
2009-04-11 12:35   
Repository: erp/stable/2.40
Changeset: 9f8225563b7842804929b4732a756a6dd659d204
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Sat Apr 11 12:34:19 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/9f8225563b7842804929b4732a756a6dd659d204 [^]

Fixes bug 0007956 Updated AD_TEXTINTERFACES

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
---
(0016248)
sureshbabu   
2009-05-11 11:22   
Tested working fine