Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0004853 | Openbravo ERP | 01. General setup | public | 2008-09-08 14:26 | 2009-04-21 11:05 |
|
| Reporter | rafaroda | |
| Assigned To | rafaroda | |
| 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 | 0004853: 'C_Currency_Convert' function does not work in PostgreSQL |
| Description | Due to UUID changes, 'C_Currency_Convert' function [1] stopped to work in PostgreSQL.
[1] https://dev.openbravo.com/websvn/openbravo/trunk/src-db/database/model/functions/C_CURRENCY_CONVERT.xml [^] |
| Steps To Reproduce | 1) Logged as System Administrator, setup a conversion rates from USD to EUR and from EUR to USD: General Setup || Application || Conversion Rates
2) Execute: SELECT C_Currency_Convert(20000, '100', '102', TO_DATE('01-01-2008'), null, '1000000', '1000000') FROM DUAL;
Yo do not get any result.
|
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2008-09-08 14:26 | rafaroda | New Issue | |
| 2008-09-08 14:26 | rafaroda | Assigned To | => cromero |
| 2008-09-08 14:26 | rafaroda | sf_bug_id | 0 => 2100094 |
| 2008-09-08 14:26 | rafaroda | Regression testing | => No |
| 2008-09-08 14:49 | rafaroda | Proposed Solution updated | |
| 2008-09-08 14:54 | rafaroda | Assigned To | cromero => rafaroda |
| 2008-09-08 15:16 | svnbot | Checkin | |
| 2008-09-08 15:16 | svnbot | Note Added: 0008920 | |
| 2008-09-08 15:16 | svnbot | Status | new => resolved |
| 2008-09-08 15:16 | svnbot | Resolution | open => fixed |
| 2008-09-08 15:16 | svnbot | svn_revision | => 7019 |
| 2008-09-09 11:04 | rafaroda | Note Added: 0008932 | |
| 2009-04-21 11:05 | psarobe | Status | resolved => closed |