Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020894Openbravo ERP09. Financial managementpublic2012-06-29 09:302012-07-26 02:42
Reporterngarcia 
Assigned Tocaristu 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP14Fixed in Version3.0MP14 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket16052
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020894: The Invoice Taxes Report does not show correct message when there is no conversion rate defined
DescriptionThe Invoice Taxes Report does not show correct message when there is no conversion rate defined
Steps To ReproduceAs Group Admin role:
   Go to the Conversion Rate screen and deactivate the conversions for a period
   Go to the Invoice Taxes Report. Select the From Date and To Date values to include the previous period between them
   Click the HTML Format button
   The following error message appears:
    
Error:
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : ReportTaxInvoiceSale

In the log you can see the following message:

Caused by: org.postgresql.util.PSQLException: ERROR: @NoConversionRate@ (USD-$) @to@ (EUR-?) @ForDate@ '31-01-2012', @Client@ 'F&B International Group' @And@ @ACCS_AD_ORG_ID_D@ 'F&B US West Coast'.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-06-29 09:30ngarciaNew Issue
2012-06-29 09:30ngarciaAssigned To => mirurita
2012-06-29 09:30ngarciaModules => Core
2012-06-29 09:30ngarciaOBNetwork customer => Yes
2012-06-29 09:30ngarciaSupport ticket => 16052
2012-06-29 09:30ngarciaResolution time => 1347487200
2012-06-29 09:44miruritaAssigned Tomirurita => jonalegriaesarte
2012-06-29 09:45ngarciaIssue Monitored: networkb
2012-07-16 13:50jonalegriaesarteAssigned Tojonalegriaesarte => caristu
2012-07-23 09:27hgbotCheckin
2012-07-23 09:27hgbotNote Added: 0050788
2012-07-23 09:27hgbotStatusnew => resolved
2012-07-23 09:27hgbotResolutionopen => fixed
2012-07-23 09:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0ecfeffd051a5a297ab1e9729ae4089a07145314 [^]
2012-07-25 13:20ngarciaStatusresolved => closed
2012-07-25 13:20ngarciaFixed in Version => 3.0MP14
2012-07-26 02:42hudsonbotCheckin
2012-07-26 02:42hudsonbotNote Added: 0050869

Notes
(0050788)
hgbot   
2012-07-23 09:27   
Repository: erp/devel/pi
Changeset: 0ecfeffd051a5a297ab1e9729ae4089a07145314
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Fri Jul 20 14:35:43 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0ecfeffd051a5a297ab1e9729ae4089a07145314 [^]

fixes issue 20894: The Invoice Taxes Report does not show correct message when there is no conversion rate defined

---
M src/org/openbravo/base/secureApp/HttpSecureAppServlet.java
---
(0050869)
hudsonbot   
2012-07-26 02:42   
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/5edf203d5780 [^]

Maturity status: Test