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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005580
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 01. General setupmajoralways2008-10-20 10:492008-12-09 13:05
ReporterrafarodaView Statuspublic 
Assigned ToHennadzi 
PriorityhighResolutionfixedFixed in Version2.35MP10
StatusclosedFix in branch2.3xFixed in SCM revision8953
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.5
OS VersionUbuntu 7.10Database version8.3Ant version1.7
Product VersionpiSCM revision8620 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005580: 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 [^]
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0005511 closedHennadzi Error on consecutive days conversion rates. 

-  Notes
(0009653)
svnbot (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2008-10-20 10:49 psarobe New Issue
2008-10-20 10:49 psarobe Assigned To => Hennadzi
2008-10-20 10:49 psarobe Status new => scheduled
2008-10-20 15:59 svnbot Checkin
2008-10-20 15:59 svnbot Note Added: 0009653
2008-10-20 15:59 svnbot Status scheduled => resolved
2008-10-20 15:59 svnbot Resolution open => fixed
2008-10-20 15:59 svnbot svn_revision => 8953
2008-12-09 13:05 psarobe Regression testing => No
2008-12-09 13:05 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker