Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004784Openbravo ERPF. Localizationpublic2008-09-01 15:122008-12-01 12:40
Reporterrafaroda 
Assigned ToAinhoaPagola 
PrioritynormalSeveritytrivialReproducibilityalways
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
Summary0004784: Review currency symbols.
DescriptionIn C_CURRENCY table inside src-db/database/masterdata [1] some currencies are missing their symbol.

Besides, some like the euro have a non-official symbol [2].

All currency symbols need to be reviewed.

[1] https://dev.openbravo.com/websvn/openbravo/trunk/src-db/database/masterdata/C_CURRENCY.xml [^]
[2] http://en.wikipedia.org/wiki/List_of_circulating_currencies [^]
Steps To ReproduceExecute: SELECT * FROM C_CURRENCY WHERE CURSYMBOL IS NULL;
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 00021812.50 closed rafaroda Currency in reports - non accounting reports 
related to feature request 00042742.50 closed rmorley Currency in reports - Accounting reports 
depends on backport 0005780 closed AinhoaPagola Review currency symbols. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-01 15:12rafarodaNew Issue
2008-09-01 15:12rafarodaAssigned To => dalsasua
2008-09-01 15:12rafarodasf_bug_id0 => 2086826
2008-09-01 15:12rafarodaOBNetwork customer => No
2008-09-01 15:12rafarodaRegression testing => No
2008-09-01 15:13rafarodaSummaryReview curency symbols. => Review currency symbols.
2008-09-29 11:50rafarodaRelationship addedrelated to 0002181
2008-09-29 11:50rafarodaRelationship addedrelated to 0004274
2008-10-30 17:56rafarodaAssigned Todalsasua => AinhoaPagola
2008-10-31 14:15rafarodaSeverityminor => trivial
2008-10-31 14:15rafarodaTypefeature request => defect
2008-10-31 14:16rafarodaStatusnew => scheduled
2008-10-31 14:16rafarodafix_in_branch => trunk
2008-10-31 16:20svnbotCheckin
2008-10-31 16:20svnbotNote Added: 0009894
2008-10-31 16:20svnbotStatusscheduled => resolved
2008-10-31 16:20svnbotResolutionopen => fixed
2008-10-31 16:20svnbotsvn_revision => 9522
2008-10-31 17:24svnbotCheckin
2008-10-31 17:24svnbotNote Added: 0009895
2008-10-31 17:24svnbotsvn_revision9522 => 9527
2008-11-20 15:21svnbotCheckin
2008-11-20 15:21svnbotNote Added: 0010447
2008-11-20 15:21svnbotsvn_revision9527 => 10328
2008-11-25 11:41psarobeNote Added: 0010619
2008-12-01 12:40krishnaStatusresolved => closed

Notes
(0009894)
svnbot   
2008-10-31 16:20   
Repository: openbravo
Revision: 9522
Author: AinhoaPagola
Date: 2008-10-31 16:20:14 +0100 (Fri, 31 Oct 2008)

Fixes bug 0004784. Currency symbols reviewed

---
U trunk/src-db/database/masterdata/C_CURRENCY.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9522&sc=1 [^]
(0009895)
svnbot   
2008-10-31 17:24   
Repository: openbravo
Revision: 9527
Author: AinhoaPagola
Date: 2008-10-31 17:24:12 +0100 (Fri, 31 Oct 2008)

Fixes bug 0004784. Currency symbols reviewed.

---
U branches/r2.40/src-db/database/masterdata/C_CURRENCY.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9527&sc=1 [^]
(0010447)
svnbot   
2008-11-20 15:21   
Repository: openbravo
Revision: 10328
Author: villind
Date: 2008-11-20 15:21:07 +0100 (Thu, 20 Nov 2008)

Merged r9527. Fixes bug 0004784. Currency symbols reviewed.

---
_U branches/bonware/r2.40/
_U branches/bonware/r2.40/config/setup-tool/
_U branches/bonware/r2.40/eclipse.install.source.launch
_U branches/bonware/r2.40/export.database.launch
_U branches/bonware/r2.40/src-core/src/org/openbravo/database/OpenbravoDriverManagerConnectionFactory.java
U branches/bonware/r2.40/src-db/database/masterdata/C_CURRENCY.xml
_U branches/bonware/r2.40/update.database.launch
---

https://dev.openbravo.com/websvn/openbravo/?rev=10328&sc=1 [^]
(0010619)
psarobe   
2008-11-25 11:41   
To verify this execute the query:

SELECT count(*) FROM C_CURRENCY WHERE CURSYMBOL IS NULL;

It should give you 0