Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021693Openbravo ERP09. Financial managementpublic2012-09-20 10:052012-09-28 14:39
Reporterxabiermerino 
Assigned ToioritzCia 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP14 
Target Version3.0MP16Fixed in Version 
Merge Request Status
Review Assigned Toxabiermerino
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021693: Invoices Tax Report shows incorrect data
DescriptionIf you change the currency rate of an invoice in the tab 'Exchange rate', the Invoices Tax Report does not take it into account
Steps To Reproduce- As admin change the currency of the price list 'Tarifa de ventas' to USD
- Create a sales invoice:
     - Tax: Entregas IVA 18%
     - Price: 100
- Go to the tab 'Exchange Rates'
     - From USD to EUR
     - Rate: 0.5
- Complete and post it
- Realize that the journal entry to the spanish accounting schema is:
43000 Clientes (euros) a corto plazo 59.00
47700 Hacienda Pública IVA repercutido 9.00
70000 Ventas de mercaderías 50.00 ---> (OK)

- Go to the Invoice Tax Report
- Filter by the date, sales transaction, EUR and organization *.
- The report shows this information (see file attached):
            
1000037 20-09-2012 Alimentos y Supermercados, S.A 68.97€ 12.41€

The report should show the information with the rate defined in the tab 'Exchange rate'

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespdf ReportTaxInvoice.pdf (2,189) 2012-09-20 10:05
https://issues.openbravo.com/file_download.php?file_id=5585&type=bug
Issue History
Date ModifiedUsernameFieldChange
2012-09-20 10:05xabiermerinoNew Issue
2012-09-20 10:05xabiermerinoAssigned To => dmiguelez
2012-09-20 10:05xabiermerinoFile Added: ReportTaxInvoice.pdf
2012-09-20 10:05xabiermerinoModules => Core
2012-09-20 10:05xabiermerinoResolution time => 1351029600
2012-09-20 10:08xabiermerinoPriorityurgent => immediate
2012-09-20 10:10xabiermerinoSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=3877#r3877
2012-09-20 10:29jonalegriaesarteAssigned Todmiguelez => ioritzCia
2012-09-25 09:11ioritzCiaNote Added: 0052522
2012-09-25 09:12hgbotCheckin
2012-09-25 09:12hgbotNote Added: 0052523
2012-09-25 09:12hgbotStatusnew => resolved
2012-09-25 09:12hgbotResolutionopen => fixed
2012-09-25 09:12hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/41ed8d602a1290c76a560abac6078cb6072d8a6e [^]
2012-09-25 10:13hgbotCheckin
2012-09-25 10:13hgbotNote Added: 0052536
2012-09-25 10:13hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/41ed8d602a1290c76a560abac6078cb6072d8a6e [^] => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/431a11781aa04e7b6f79dca41bb2e0ca795cff49 [^]
2012-09-25 10:14ioritzCiaNote Added: 0052537
2012-09-25 11:59xabiermerinoClosed by => xabiermerino
2012-09-25 11:59xabiermerinoNote Added: 0052546
2012-09-25 11:59xabiermerinoStatusresolved => closed
2012-09-28 14:39hudsonbotCheckin
2012-09-28 14:39hudsonbotNote Added: 0052895

Notes
(0052522)
ioritzCia   
2012-09-25 09:11   
Testing Plan:

- Follow the steps to reproduce.
(0052523)
hgbot   
2012-09-25 09:12   
Repository: erp/devel/pi
Changeset: 41ed8d602a1290c76a560abac6078cb6072d8a6e
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Fri Sep 21 10:51:10 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/41ed8d602a1290c76a560abac6078cb6072d8a6e [^]

Fixes issue 21693: Invoices Tax Report shows incorrect data.

---
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
A src-db/database/model/functions/C_CURRENCY_CONVERT_RATE.xml
---
(0052536)
hgbot   
2012-09-25 10:13   
Repository: erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30
Changeset: 431a11781aa04e7b6f79dca41bb2e0ca795cff49
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Tue Sep 25 10:04:45 2012 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30/rev/431a11781aa04e7b6f79dca41bb2e0ca795cff49 [^]

Fixes issue 21693: Invoices Tax Report shows incorrect data.

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/module/invoiceTaxReportEnhanced30/ad_reports/OBMTR30InvoiceTaxReportDao.java
M src/org/openbravo/module/invoiceTaxReportEnhanced30/ad_reports/OBMTR30_InvoiceTaxReportJR.java
M src/org/openbravo/module/invoiceTaxReportEnhanced30/api/MTRRecord.java
M src/org/openbravo/module/invoiceTaxReportEnhanced30/utility/Utility.java
---
(0052537)
ioritzCia   
2012-09-25 10:14   
This must be also tested in Multidimensional Tax Report.
(0052546)
xabiermerino   
2012-09-25 11:59   
verified
(0052895)
hudsonbot   
2012-09-28 14:39   
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/6d2f8cffd4b1 [^]

Maturity status: Test