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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0007956
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 07. Sales managementcriticalalways2009-03-05 09:152009-05-11 11:22
ReporternetworkbView Statuspublic 
Assigned Torafaroda 
PriorityimmediateResolutionfixedFixed in Version2.40MP4
StatusclosedFix in branch2.40Fixed in SCM revision9f8225563b78
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP1SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007956: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0007957 closedrafaroda Multi currency issues in some processes and tables 
related to backport 0008541 closedrafaroda Warehouse Reports do not handle currencies 
related to backport 0008543 closedrafaroda Production Reports do not handle currencies 
related to backport 0008545 closedrafaroda Projects Reports do not handle currencies 
blocks defect 0007955 closedrafaroda Sales Reports do not handle currencies 
blocks backport 0007305 closedrafaroda Procurement reports do not handle currencies 

-  Notes
(0015327)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (reporter)
2009-05-11 11:22

 Tested working fine

- Issue History
Date Modified Username Field Change
2009-03-05 09:16 rafaroda Type defect => backport
2009-03-05 09:16 rafaroda fix_in_branch => 2.40
2009-03-05 09:18 rafaroda Relationship added blocks 0007305
2009-03-05 09:22 rafaroda Relationship added depends on 0007957
2009-03-05 09:26 rafaroda Steps to Reproduce Updated
2009-04-11 11:55 rafaroda Summary Reports do not handle currencies => Sales Reports do not handle currencies
2009-04-11 11:55 rafaroda Description Updated
2009-04-11 11:55 rafaroda Steps to Reproduce Updated
2009-04-11 12:35 hgbot Checkin
2009-04-11 12:35 hgbot Note Added: 0015327
2009-04-11 12:35 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/16f5c3b103d23bfd0224fcac8b374e852bce4362 [^]
2009-04-11 12:35 hgbot Checkin
2009-04-11 12:35 hgbot Note Added: 0015328
2009-04-11 12:35 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/16f5c3b103d23bfd0224fcac8b374e852bce4362 [^] => http://code.openbravo.com/erp/stable/2.40/rev/224cd114cec47ee0ae74efe4c3ba858f20b61a2a [^]
2009-04-11 12:35 hgbot Checkin
2009-04-11 12:35 hgbot Note Added: 0015329
2009-04-11 12:35 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/224cd114cec47ee0ae74efe4c3ba858f20b61a2a [^] => http://code.openbravo.com/erp/stable/2.40/rev/3b4c86f41532aef99d7255d6bf23da515650e860 [^]
2009-04-11 12:35 hgbot Checkin
2009-04-11 12:35 hgbot Note Added: 0015330
2009-04-11 12:35 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/3b4c86f41532aef99d7255d6bf23da515650e860 [^] => http://code.openbravo.com/erp/stable/2.40/rev/2049ddb02c5a8fe8a7d214a62563952a7747217b [^]
2009-04-11 12:35 hgbot Checkin
2009-04-11 12:35 hgbot Note Added: 0015331
2009-04-11 12:35 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/2049ddb02c5a8fe8a7d214a62563952a7747217b [^] => http://code.openbravo.com/erp/stable/2.40/rev/aed98d367f22566bfec581a27342b1fa94a06e49 [^]
2009-04-11 12:35 hgbot Checkin
2009-04-11 12:35 hgbot Note Added: 0015332
2009-04-11 12:35 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/aed98d367f22566bfec581a27342b1fa94a06e49 [^] => http://code.openbravo.com/erp/stable/2.40/rev/5a4227ba53f018888d1255325a556360e32c783e [^]
2009-04-11 12:35 hgbot Checkin
2009-04-11 12:35 hgbot Note Added: 0015333
2009-04-11 12:35 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/5a4227ba53f018888d1255325a556360e32c783e [^] => http://code.openbravo.com/erp/stable/2.40/rev/432da3a14b065a90d4821777a9036f585de534ec [^]
2009-04-11 12:35 hgbot Checkin
2009-04-11 12:35 hgbot Note Added: 0015334
2009-04-11 12:35 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/432da3a14b065a90d4821777a9036f585de534ec [^] => http://code.openbravo.com/erp/stable/2.40/rev/7c00d218d646694eb1a69d5d00d915e415f4fefd [^]
2009-04-11 12:35 hgbot Checkin
2009-04-11 12:35 hgbot Note Added: 0015335
2009-04-11 12:35 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/7c00d218d646694eb1a69d5d00d915e415f4fefd [^] => http://code.openbravo.com/erp/stable/2.40/rev/5e9aec8d8a9b759cb65e9b577edf6fab67c173ee [^]
2009-04-11 12:35 hgbot Checkin
2009-04-11 12:35 hgbot Note Added: 0015336
2009-04-11 12:35 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/5e9aec8d8a9b759cb65e9b577edf6fab67c173ee [^] => http://code.openbravo.com/erp/stable/2.40/rev/49ba7ff153440febf774a24ccadbb1c801c32636 [^]
2009-04-11 12:35 hgbot Checkin
2009-04-11 12:35 hgbot Note Added: 0015337
2009-04-11 12:35 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/49ba7ff153440febf774a24ccadbb1c801c32636 [^] => http://code.openbravo.com/erp/stable/2.40/rev/553f41adc4904d67ada989a5828347223e3d2371 [^]
2009-04-11 12:35 hgbot Checkin
2009-04-11 12:35 hgbot Note Added: 0015338
2009-04-11 12:35 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/553f41adc4904d67ada989a5828347223e3d2371 [^] => http://code.openbravo.com/erp/stable/2.40/rev/eb4ed70872b88b2d3e7104c186d1af0b195d2ed9 [^]
2009-04-11 12:35 hgbot Checkin
2009-04-11 12:35 hgbot Note Added: 0015339
2009-04-11 12:35 hgbot Status scheduled => resolved
2009-04-11 12:35 hgbot Resolution open => fixed
2009-04-11 12:35 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/eb4ed70872b88b2d3e7104c186d1af0b195d2ed9 [^] => http://code.openbravo.com/erp/stable/2.40/rev/9f8225563b7842804929b4732a756a6dd659d204 [^]
2009-04-11 12:45 rafaroda Relationship added related to 0008541
2009-04-11 12:46 rafaroda Relationship added related to 0008543
2009-04-11 12:49 rafaroda Relationship added related to 0008545
2009-05-10 19:37 psarobe Fixed in Version => 2.40MP4
2009-05-11 11:22 sureshbabu Status resolved => closed
2009-05-11 11:22 sureshbabu Note Added: 0016248

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker