Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0023844
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionaryminoralways2013-05-17 21:042013-06-20 02:07
ReporterpjuvaraView Statuspublic 
Assigned Topramakrishnan 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisione529969156c5
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0MP22.1SCM revision 
Review Assigned ToSandrahuguet
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023844: 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.
TagsNo tags attached.
Attached Filespng file icon Openbravo Conversion Rates 5179FDEEA86....png [^] (73,191 bytes) 2013-05-17 21:04

- Relationships Relation Graph ] Dependency Graph ]
has duplicate defect 0023959 closeddmiguelez UUID appears in the Conversion rates tab 

-  Notes
(0059188)
pramakrishnan (developer)
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 (developer)
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 (developer)
2013-06-07 08:53

Code review + testing OK
(0059550)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2013-05-17 21:04 pjuvara New Issue
2013-05-17 21:04 pjuvara Assigned To => AugustoMauch
2013-05-17 21:04 pjuvara File Added: Openbravo Conversion Rates 5179FDEEA86....png
2013-05-17 21:04 pjuvara Modules => Core
2013-05-17 21:04 pjuvara Triggers an Emergency Pack => No
2013-05-18 10:47 AugustoMauch Assigned To AugustoMauch => dmiguelez
2013-06-03 07:53 pramakrishnan Assigned To dmiguelez => pramakrishnan
2013-06-03 07:53 pramakrishnan Status new => scheduled
2013-06-03 07:53 pramakrishnan fix_in_branch => pi
2013-06-03 08:34 pramakrishnan Relationship added has duplicate 0023959
2013-06-05 15:19 pramakrishnan Note Added: 0059188
2013-06-07 08:50 hgbot Checkin
2013-06-07 08:50 hgbot Note Added: 0059255
2013-06-07 08:50 hgbot Status scheduled => resolved
2013-06-07 08:50 hgbot Resolution open => fixed
2013-06-07 08:50 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e529969156c5d4806d8fff173422b004ad0d6da0 [^]
2013-06-07 08:53 Sandrahuguet Review Assigned To => Sandrahuguet
2013-06-07 08:53 Sandrahuguet Note Added: 0059260
2013-06-07 08:53 Sandrahuguet Status resolved => closed
2013-06-20 02:07 hudsonbot Checkin
2013-06-20 02:07 hudsonbot Note Added: 0059550


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker