Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0005579 | Openbravo ERP | 01. General setup | public | 2008-10-20 10:49 | 2008-12-10 07:58 | |||||||
| Reporter | rafaroda | |||||||||||
| Assigned To | Hennadzi | |||||||||||
| Priority | high | Severity | major | Reproducibility | always | |||||||
| Status | closed | Resolution | fixed | |||||||||
| Platform | OS | 20 | OS Version | Ubuntu 7.10 | ||||||||
| Product Version | pi | |||||||||||
| Target Version | Fixed in Version | |||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | ||||||||||||
| OBNetwork customer | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Support ticket | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0005579: Error on consecutive days conversion rates. | |||||||||||
| Description | One 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 Reproduce | 1) 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 Solution | Review C_CONVERSION_RATE_TRG2: https://dev.openbravo.com/websvn/openbravo/trunk/src-db/database/model/triggers/C_CONVERSION_RATE_TRG2.xml [^] | |||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| 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:57 | svnbot | Checkin | ||||||||||
| 2008-10-20 15:57 | svnbot | Note Added: 0009652 | ||||||||||
| 2008-10-20 15:57 | svnbot | Status | scheduled => resolved | |||||||||
| 2008-10-20 15:57 | svnbot | Resolution | open => fixed | |||||||||
| 2008-10-20 15:57 | svnbot | svn_revision | => 8949 | |||||||||
| 2008-10-22 14:06 | svnbot | Checkin | ||||||||||
| 2008-10-22 14:06 | svnbot | Note Added: 0009685 | ||||||||||
| 2008-10-22 14:06 | svnbot | svn_revision | 8949 => 9018 | |||||||||
| 2008-12-10 07:58 | krishna | Regression testing | => No | |||||||||
| 2008-12-10 07:58 | krishna | Status | resolved => closed | |||||||||
| 2009-02-02 16:07 | rafaroda | Note Deleted: 0009685 | ||||||||||
| Notes | |||||
|
|
|||||
|
|
||||