Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016309Openbravo ERP09. Financial managementpublic2011-03-15 15:172011-05-26 07:45
Reportermalsasua 
Assigned Toadrianromero 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Versionpi 
Target Version2.50MP29Fixed in Version3.0MP0 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016309: General Ledger Journal in XLS format , the format of numbers are not correct
Description. if you export to XLS the General Ledger Journal, the format of numbers are not correct. You can not realize operations with the numbers
Steps To ReproduceFinancial Management || Accounting || Analysis Tools || General Ledger Journal || General Ledger Journal
. export to XLS

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00162142.50MP28 closed AinhoaPagola There are errors in General Ledger report (excel) with long numbers 
depends on defect 0017122 closed AinhoaPagola General Ledger Report in XLS format gets Strings instead of numbers 
blocks backport 0017259 closed adrianromero General Ledger Journal in XLS format , the format of numbers are not correct 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-15 15:17malsasuaNew Issue
2011-03-15 15:17malsasuaAssigned To => dalsasua
2011-03-15 15:17malsasuaModules => Core
2011-03-15 15:18malsasuaIssue Monitored: networkb
2011-03-16 13:45adrianromeroNote Added: 0034939
2011-05-09 16:57AinhoaPagolaAssigned Todalsasua => AinhoaPagola
2011-05-10 10:33AinhoaPagolaRelationship addedrelated to 0016214
2011-05-13 11:08AinhoaPagolaRelationship addeddepends on 0017122
2011-05-13 14:55AinhoaPagolaAssigned ToAinhoaPagola => dalsasua
2011-05-18 19:21adrianromeroAssigned Todalsasua => adrianromero
2011-05-18 19:21adrianromeroStatusnew => scheduled
2011-05-18 19:21adrianromeroversion => pi
2011-05-18 19:24adrianromeroIssue cloned0017259
2011-05-18 19:24adrianromeroRelationship addedblocks 0017259
2011-05-19 11:36hgbotCheckin
2011-05-19 11:36hgbotNote Added: 0037200
2011-05-19 11:36hgbotStatusscheduled => resolved
2011-05-19 11:36hgbotResolutionopen => fixed
2011-05-19 11:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f263796bd669f747d644ff46e9fe7bab783103ee [^]
2011-05-19 11:36hgbotCheckin
2011-05-19 11:36hgbotNote Added: 0037201
2011-05-19 11:36hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/f263796bd669f747d644ff46e9fe7bab783103ee [^] => http://code.openbravo.com/erp/devel/pi/rev/5f7a1c15677a837fa32a22147fb866da596f01cc [^]
2011-05-19 12:29hgbotCheckin
2011-05-19 12:29hgbotNote Added: 0037215
2011-05-19 12:29hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/5f7a1c15677a837fa32a22147fb866da596f01cc [^] => http://code.openbravo.com/erp/devel/pi/rev/f50511381b8b1776744281d7f8ab52f4a215ed39 [^]
2011-05-19 12:42adrianromeroNote Added: 0037217
2011-05-23 16:58jonalegriaesarteNote Added: 0037341
2011-05-23 16:58jonalegriaesarteStatusresolved => closed
2011-05-23 16:58jonalegriaesarteFixed in Version => 3.0MP0
2011-05-26 07:45hudsonbotCheckin
2011-05-26 07:45hudsonbotNote Added: 0037501
2011-05-26 07:45hudsonbotCheckin
2011-05-26 07:45hudsonbotNote Added: 0037502
2011-05-26 07:45hudsonbotCheckin
2011-05-26 07:45hudsonbotNote Added: 0037505

Notes
(0034939)
adrianromero   
2011-03-16 13:45   
The problem is that numbers in the exported xls have a ' before the numeric figures. This is why it works with the + operator but it does not work with the SUM function

Have a look at the Trial Balance Report because the exported xls it works properly.
(0037200)
hgbot   
2011-05-19 11:36   
Repository: erp/devel/pi
Changeset: f263796bd669f747d644ff46e9fe7bab783103ee
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Wed May 18 19:25:56 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f263796bd669f747d644ff46e9fe7bab783103ee [^]

Fixes issue 0016309: General Ledger Journal in XLS format , the format of numbers are not correct
It has been created a new report for excel with the correct formatting options

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.java
A src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalExcel.jrxml
---
(0037201)
hgbot   
2011-05-19 11:36   
Repository: erp/devel/pi
Changeset: 5f7a1c15677a837fa32a22147fb866da596f01cc
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu May 19 11:31:59 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5f7a1c15677a837fa32a22147fb866da596f01cc [^]

Fixes issue 0016309: General Ledger Journal in XLS format , the format of numbers are not correct
Added translations for database consistency

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
---
(0037215)
hgbot   
2011-05-19 12:29   
Repository: erp/devel/pi
Changeset: f50511381b8b1776744281d7f8ab52f4a215ed39
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu May 19 12:28:48 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f50511381b8b1776744281d7f8ab52f4a215ed39 [^]

Fixes issue 0016309: General Ledger Journal in XLS format , the format of numbers are not correct
Fixing entry number sequence

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalExcel.jrxml
---
(0037217)
adrianromero   
2011-05-19 12:42   
* Testing the issue

Go to the Report General Ledger Journal, execute it and export it to excel. Verify that a new excel report is generated with numbers in its cells that can be used for operations. Verify also that the pdf reports is still the same with the previous layout.

* Other areas affected.

No other areas affected.
(0037341)
jonalegriaesarte   
2011-05-23 16:58   
Verified
(0037501)
hudsonbot   
2011-05-26 07:45   
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/728387046be6 [^]

Maturity status: Test
(0037502)
hudsonbot   
2011-05-26 07:45   
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/728387046be6 [^]

Maturity status: Test
(0037505)
hudsonbot   
2011-05-26 07:45   
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/728387046be6 [^]

Maturity status: Test