Openbravo Issue Tracking System - Openbravo ERP | |||||||||||||||||||
| View Issue Details | |||||||||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||||||||
| 0005511 | Openbravo ERP | 01. General setup | public | 2008-10-13 14:50 | 2008-12-03 10:09 | ||||||||||||||
| 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 | 0005511: 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-13 14:50 | rafaroda | New Issue | |||||||||||||||||
| 2008-10-13 14:50 | rafaroda | Assigned To | => cromero | ||||||||||||||||
| 2008-10-13 14:50 | rafaroda | sf_bug_id | 0 => 2163534 | ||||||||||||||||
| 2008-10-13 14:50 | rafaroda | Regression testing | => No | ||||||||||||||||
| 2008-10-20 10:49 | psarobe | Status | new => scheduled | ||||||||||||||||
| 2008-10-20 10:49 | psarobe | Assigned To | cromero => Hennadzi | ||||||||||||||||
| 2008-10-20 10:49 | psarobe | fix_in_branch | => trunk | ||||||||||||||||
| 2008-10-20 15:55 | svnbot | Checkin | |||||||||||||||||
| 2008-10-20 15:55 | svnbot | Note Added: 0009651 | |||||||||||||||||
| 2008-10-20 15:55 | svnbot | Status | scheduled => resolved | ||||||||||||||||
| 2008-10-20 15:55 | svnbot | Resolution | open => fixed | ||||||||||||||||
| 2008-10-20 15:55 | svnbot | svn_revision | => 8948 | ||||||||||||||||
| 2008-12-03 10:09 | krishna | Status | resolved => closed | ||||||||||||||||
| Notes | |||||
|
|
|||||
|
|
||||