Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005580Openbravo ERP01. General setuppublic2008-10-20 10:492008-12-09 13:05
Reporterrafaroda 
Assigned ToHennadzi 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target VersionFixed in Version2.35MP10 
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
Summary0005580: Error on consecutive days conversion rates.
DescriptionOne can not setup two conversion rates in consecutive days with error message: ERROR: There are different conversion rates with same dates

This bug also reproduces in 2.3x and 2.40 branches.
Steps To Reproduce1) Go to 'General Setup || Application || Conversion Rates'
2) Create a conversion rate from EUR to USD with starting and ending date equals to '14-10-2008'.
3) Create a new conversion rate from EUR to USD with starting and ending date equals to '15-10-2008'.

You get the following error:
12:08:09 [http-8384-Processor20] ERROR org.openbravo.erpWindows.ConversionRates.ConversionRateData - SQL error in query: INSERT INTO C_Conversion_Rate (C_Conversion_Rate_ID, AD_Client_ID, AD_Org_ID, C_Currency_ID, C_Currency_ID_To, IsActive, ConversionRateType, ValidFrom, ValidTo, MultiplyRate, DivideRate, created, createdby, updated, updatedBy) VALUES ((?), (?), (?), (?), (?), (?), (?), TO_DATE(?), TO_DATE(?), TO_NUMBER(?), TO_NUMBER(?), now(), ?, now(), ?)Exception:org.postgresql.util.PSQLException: ERROR: There are different conversion rates with same dates
Proposed SolutionReview C_CONVERSION_RATE_TRG2: https://dev.openbravo.com/websvn/openbravo/trunk/src-db/database/model/triggers/C_CONVERSION_RATE_TRG2.xml [^]
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0005511 closed Hennadzi Error on consecutive days conversion rates. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-10-20 10:49psarobeNew Issue
2008-10-20 10:49psarobeAssigned To => Hennadzi
2008-10-20 10:49psarobeStatusnew => scheduled
2008-10-20 15:59svnbotCheckin
2008-10-20 15:59svnbotNote Added: 0009653
2008-10-20 15:59svnbotStatusscheduled => resolved
2008-10-20 15:59svnbotResolutionopen => fixed
2008-10-20 15:59svnbotsvn_revision => 8953
2008-12-09 13:05psarobeRegression testing => No
2008-12-09 13:05psarobeStatusresolved => closed

Notes
(0009653)
svnbot   
2008-10-20 15:59   
Repository: openbravo
Revision: 8953
Author: hennadzi
Date: 2008-10-20 15:59:17 +0200 (Mon, 20 Oct 2008)

Fixed bug 0005580: Error on consecutive days conversion rates.

---
U branches/r2.3x/database/model/triggers/C_CONVERSION_RATE_TRG2.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=8953&sc=1 [^]