Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009895Openbravo ERP09. Financial managementpublic2009-07-14 17:212009-08-01 00:00
Reporternetworkb 
Assigned Toharikrishnan 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version2.40MP4 
Target VersionFixed in Versionpi 
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
Summary0009895: Invoice tax report does not handle currencies.
DescriptionInvoice tax report does not handle currencies.
Different currencies are mixed in the invoice tax report for purchases (and also sales).
Steps To Reproduce-Create an invoice using the currency of the schema
-Create an invoice using a foreign currency. In the lines use
the same tax that you used in the lines of the previous invoice.
-Go to Financial Management || Receivables & Payables || Analysis Tools || Invoice Taxes Report || Invoice Taxes Report
-Execute the report and see that the currencies are mixed.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0009896 closed harikrishnan Invoice tax report does not handle currencies. 
Attached Filespng ResultOfInvoiceTaxesReport.png (151,882) 2009-07-17 07:02
https://issues.openbravo.com/file_download.php?file_id=1552&type=bug
png

png InvoiceTaxesReport.png (171,408) 2009-07-17 07:02
https://issues.openbravo.com/file_download.php?file_id=1553&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2009-07-14 17:21networkbNew Issue
2009-07-14 17:21networkbAssigned To => rafaroda
2009-07-14 17:26rafarodaAssigned Torafaroda => sathiyan
2009-07-14 17:26rafarodaStatusnew => scheduled
2009-07-14 17:26rafarodafix_in_branch => pi
2009-07-17 07:02sathiyanFile Added: ResultOfInvoiceTaxesReport.png
2009-07-17 07:02sathiyanFile Added: InvoiceTaxesReport.png
2009-07-17 07:11sathiyanNote Added: 0018342
2009-07-17 07:15rafarodaNote Added: 0018343
2009-07-17 07:26sathiyanAssigned Tosathiyan => harikrishnan
2009-07-24 13:37hgbotCheckin
2009-07-24 13:37hgbotNote Added: 0018605
2009-07-24 13:37hgbotStatusscheduled => resolved
2009-07-24 13:37hgbotResolutionopen => fixed
2009-07-24 13:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f5acd1a762300fef11a280ed19b5e67ce1e27a13 [^]
2009-07-31 11:53sureshbabuStatusresolved => closed
2009-07-31 11:53sureshbabuNote Added: 0018757
2009-07-31 11:53sureshbabuFixed in Version => pi
2009-08-01 00:00anonymoussf_bug_id0 => 2830570

Notes
(0018342)
sathiyan   
2009-07-17 07:11   
I have attached two screen shots.
I have done one sales invoice transaction with USD and other transaction with Euro.
Screen shot1(RsultOfInvoiceTaxesReport): As reporter suggest it just shows the mix of all currencies with out any distinction.
Screen Shot2(InvoiceTaxReport): Currently we dont have currency field in the screen of InvoiceTaxReport screen (Financial Management || Receivables & Payables || Analysis Tools || Invoice Taxes Report || Invoice Taxes Report )

I need clarification on

1) Should I include currency field in the screen and give choice to user to choose.
(OR)
2) Should I show the report in base currency (if they set conversion rates properly in the system for base currency to used currencies at General Setup || Application || Conversion Rates || Conversion Rate )

Regards
Sathiyan.
(0018343)
rafaroda   
2009-07-17 07:15   
Filter window must display the currency drop-down and the report amounts have to be converted to the currency selected. If there is no conversion rate for any of the transactions an error message should appear. http://wiki.openbravo.com/wiki/Projects/Multi_Currency_Reports_Review [^]
(0018605)
hgbot   
2009-07-24 13:37   
Repository: erp/devel/pi
Changeset: f5acd1a762300fef11a280ed19b5e67ce1e27a13
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Fri Jul 24 17:00:02 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/f5acd1a762300fef11a280ed19b5e67ce1e27a13 [^]

Fixes Issue 9895: Invoice tax report does not handle currencies.

---
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoice.html
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoice.java
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoice.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoice.xml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoicePurchase.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoicePurchaseForeign.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSale.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSaleForeign.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoice_data.xsql
---
(0018757)
sureshbabu   
2009-07-31 11:53   
Tested, working fine