Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023844Openbravo ERP00. Application dictionarypublic2013-05-17 21:042013-06-20 02:07
Reporterpjuvara 
Assigned Topramakrishnan 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP22.1 
Target VersionFixed in Version 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023844: Invalid Record Identifier for Conversion Rates
DescriptionThe table C_CONVERSION_RATE does not have a proper definition for record identifiers.
The column C_CONVERSION_RATE_ID is marked as the sole record identifier (Use as Record Identifier set to Y).

As a result, the Conversion Rate window records are identified using the internal ID.
Steps To ReproduceSee attached screenshot.
Proposed SolutionDefine a human readable record identifier composed by the following three columns:
- C_CURRENCY_ID
- C_CURRENCY_ID_TO
- VALIDFROM

this will generate an identifier that looks like "USD - EUR - 01/01/2013" which allows users to understand which conversion rate they are referring to.
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0023959 closed dmiguelez UUID appears in the Conversion rates tab 
Attached Filespng Openbravo Conversion Rates 5179FDEEA86....png (73,191) 2013-05-17 21:04
https://issues.openbravo.com/file_download.php?file_id=6141&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2013-05-17 21:04pjuvaraNew Issue
2013-05-17 21:04pjuvaraAssigned To => AugustoMauch
2013-05-17 21:04pjuvaraFile Added: Openbravo Conversion Rates 5179FDEEA86....png
2013-05-17 21:04pjuvaraModules => Core
2013-05-17 21:04pjuvaraTriggers an Emergency Pack => No
2013-05-18 10:47AugustoMauchAssigned ToAugustoMauch => dmiguelez
2013-06-03 07:53pramakrishnanAssigned Todmiguelez => pramakrishnan
2013-06-03 07:53pramakrishnanStatusnew => scheduled
2013-06-03 07:53pramakrishnanfix_in_branch => pi
2013-06-03 08:34pramakrishnanRelationship addedhas duplicate 0023959
2013-06-05 15:19pramakrishnanNote Added: 0059188
2013-06-07 08:50hgbotCheckin
2013-06-07 08:50hgbotNote Added: 0059255
2013-06-07 08:50hgbotStatusscheduled => resolved
2013-06-07 08:50hgbotResolutionopen => fixed
2013-06-07 08:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e529969156c5d4806d8fff173422b004ad0d6da0 [^]
2013-06-07 08:53SandrahuguetReview Assigned To => Sandrahuguet
2013-06-07 08:53SandrahuguetNote Added: 0059260
2013-06-07 08:53SandrahuguetStatusresolved => closed
2013-06-20 02:07hudsonbotCheckin
2013-06-20 02:07hudsonbotNote Added: 0059550

Notes
(0059188)
pramakrishnan   
2013-06-05 15:19   
Test Plan:
Login as Openbravo/openbravo
Navigate to conversion rate window
Select any record
Notice that the tab header displays the identifier as "Currency - To Currency - Valid From"
(0059255)
hgbot   
2013-06-07 08:50   
Repository: erp/devel/pi
Changeset: e529969156c5d4806d8fff173422b004ad0d6da0
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Mon Jun 03 11:29:35 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/e529969156c5d4806d8fff173422b004ad0d6da0 [^]

Fixes issue 23844: Invalid Record Identifier for Conversion Rates

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0059260)
Sandrahuguet   
2013-06-07 08:53   
Code review + testing OK
(0059550)
hudsonbot   
2013-06-20 02:07   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5caf871044ad [^]

Maturity status: Test