Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019696Openbravo ERP09. Financial managementpublic2012-02-09 04:512012-04-26 10:36
Reporterboris 
Assigned Tomigueldejuana 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS30OS VersionCentOS 6
Product Version3.0MP7.1 
Target VersionFixed in Version3.0MP11 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019696: CSV export of Currency is in two digits
DescriptionExport an Cuurency to csv. The "Multiple Rate By" and "Divide Rate By" are just in 2 digit accuracy (making them useless for exporting exchange rates).
Steps To ReproduceGo to Currency. Select a currency that has Conversion Rates. Click on the export button. Oh, and make sure you have rates with a higher precision than two digits.

For example:
"To Currency","Valid From Date","Valid To Date","Multiple Rate By","Divide Rate By"
"HKD","24-03-2006","25-03-2006",9.29,0.11

That is the result of the HK$ rate. It should have exported this: 9.2875
Proposed SolutionWhen exporting to CSV use the same precision as is stored in the database.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-02-09 04:51borisNew Issue
2012-02-09 04:51borisAssigned To => jonalegriaesarte
2012-02-09 04:51borisWeb browser => Google Chrome
2012-02-09 04:51borisModules => Core
2012-04-03 12:20jonalegriaesarteAssigned Tojonalegriaesarte => vmromanos
2012-04-11 09:45vmromanosAssigned Tovmromanos => alostale
2012-04-19 08:46alostaleAssigned Toalostale => migueldejuana
2012-04-20 11:18hgbotCheckin
2012-04-20 11:18hgbotNote Added: 0047781
2012-04-20 11:18hgbotStatusnew => resolved
2012-04-20 11:18hgbotResolutionopen => fixed
2012-04-20 11:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7e96bd54d7b0a9c144f3ab1f80fed9eccf230648 [^]
2012-04-20 11:21migueldejuanaNote Added: 0047782
2012-04-21 14:24hudsonbotCheckin
2012-04-21 14:24hudsonbotNote Added: 0047852
2012-04-26 10:36alostaleNote Added: 0047993
2012-04-26 10:36alostaleStatusresolved => closed
2012-04-26 10:36alostaleFixed in Version => 3.0MP11

Notes
(0047781)
hgbot   
2012-04-20 11:18   
Repository: erp/devel/pi
Changeset: 7e96bd54d7b0a9c144f3ab1f80fed9eccf230648
Author: Miguel de Juana <miguel.dejuana <at> openbravo.com>
Date: Fri Apr 20 11:17:28 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7e96bd54d7b0a9c144f3ab1f80fed9eccf230648 [^]

Fixed issue 19696: Multiple & Divide Rate in ConversionRate csv use 6 decimals
Exporting to Spreadsheet in Currency - Conversion Rates, the Multiple Rate by an Divide Rate by columns show the value only with 2 digits precision. It has been updated and now it shows 6 digits precision as same as the grid/form.

---
M modules/org.openbravo.client.kernel/src-db/database/sourcedata/OBCLKER_UIDEFINITION.xml
M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/reference/NumberUIDefinition.java
---
(0047782)
migueldejuana   
2012-04-20 11:21   
Test plan:

- Go to Currency
- Create a Conversion Rate in one Currency (use more than 2 decimals in the value of Multiple Rate by and Divide Rate by columns)
- Export this Conversion Rate



It should be no risky.
(0047852)
hudsonbot   
2012-04-21 14:24   
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/2eb57286c1fc [^]

Maturity status: Test
(0047993)
alostale   
2012-04-26 10:36   
Code reviewed and verified in pi@9d54745371d5