Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004853Openbravo ERP01. General setuppublic2008-09-08 14:262009-04-21 11:05
Reporterrafaroda 
Assigned Torafaroda 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004853: 'C_Currency_Convert' function does not work in PostgreSQL
DescriptionDue 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 Reproduce1) 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
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-08 14:26rafarodaNew Issue
2008-09-08 14:26rafarodaAssigned To => cromero
2008-09-08 14:26rafarodasf_bug_id0 => 2100094
2008-09-08 14:26rafarodaOBNetwork customer => No
2008-09-08 14:26rafarodaRegression testing => No
2008-09-08 14:49rafarodaProposed Solution updated
2008-09-08 14:54rafarodaAssigned Tocromero => rafaroda
2008-09-08 15:16svnbotCheckin
2008-09-08 15:16svnbotNote Added: 0008920
2008-09-08 15:16svnbotStatusnew => resolved
2008-09-08 15:16svnbotResolutionopen => fixed
2008-09-08 15:16svnbotsvn_revision => 7019
2008-09-09 11:04rafarodaNote Added: 0008932
2009-04-21 11:05psarobeStatusresolved => closed

Notes
(0008920)
svnbot   
2008-09-08 15:16   
Repository: openbravo
Revision: 7019
Author: rafaroda
Date: 2008-09-08 15:16:31 +0200 (Mon, 08 Sep 2008)

Fixes bug 0004853 Changed NUMBERs to VARCHARs inside C_CURRENCY_RATE.xml.

---
U trunk/src-db/database/model/functions/C_CURRENCY_RATE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=7019&sc=1 [^]
(0008932)
rafaroda   
2008-09-09 11:04   
In fact, they had to be changed by VARCHAR(32): https://dev.openbravo.com/websvn/openbravo/trunk/src-db/database/model/functions/C_CURRENCY_RATE.xml?op=diff&rev=7069&sc=1 [^]

Correctly fixed in bug https://issues.openbravo.com/view.php?id=4863 [^]