Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017122Openbravo ERP09. Financial managementpublic2011-05-11 17:032011-05-24 12:41
ReporterAinhoaPagola 
Assigned ToAinhoaPagola 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
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
Summary0017122: General Ledger Report in XLS format gets Strings instead of numbers
DescriptionIn the General Ledger Report, in the XLS version, the Credit and Debit fields are Strings instead of Numbers. Strings have a ' before the numeric figures.

This is why operations like + work OK but SUM function and similars don't.
Steps To ReproduceOpen the General Ledger Report in XSL.
Proposed SolutionInstead of:
<textFieldExpression class="java.lang.String"><![CDATA[($F{AMTACCTCR}!=BigDecimal.ZERO && $F{AMTACCTCR}!=null)?$P{NUMBERFORMAT}.format($F{AMTACCTCR}).toString():new String(" ")]]></textFieldExpression>

Have:
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AMTACCTCR}]]></textFieldExpression>

                  
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 backport 0017123 closed AinhoaPagola General Ledger Report in XLS format gets Strings instead of numbers 
blocks defect 00163092.50MP29 closed adrianromero General Ledger Journal in XLS format , the format of numbers are not correct 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-05-11 17:03AinhoaPagolaNew Issue
2011-05-11 17:03AinhoaPagolaAssigned To => AinhoaPagola
2011-05-11 17:03AinhoaPagolaModules => Core
2011-05-11 17:03AinhoaPagolaOBNetwork customer => No
2011-05-11 17:03AinhoaPagolaStatusnew => scheduled
2011-05-11 17:03AinhoaPagolafix_in_branch => pi
2011-05-11 17:54AinhoaPagolaRelationship addedrelated to 0016214
2011-05-12 09:14hgbotCheckin
2011-05-12 09:14hgbotNote Added: 0036704
2011-05-12 09:14hgbotStatusscheduled => resolved
2011-05-12 09:14hgbotResolutionopen => fixed
2011-05-12 09:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/08a220fdf2eaccc01044dc1e7428bdc444bd1454 [^]
2011-05-13 06:22hudsonbotCheckin
2011-05-13 06:22hudsonbotNote Added: 0036930
2011-05-13 11:08AinhoaPagolaRelationship addedblocks 0016309
2011-05-24 12:41adrianromeroNote Added: 0037374
2011-05-24 12:41adrianromeroStatusresolved => closed

Notes
(0036704)
hgbot   
2011-05-12 09:14   
Repository: erp/devel/pi
Changeset: 08a220fdf2eaccc01044dc1e7428bdc444bd1454
Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com>
Date: Wed May 11 18:06:05 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/08a220fdf2eaccc01044dc1e7428bdc444bd1454 [^]

Fixes issue 17122. GLR in XLS format gets numbers

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerExcel.jrxml
---
(0036930)
hudsonbot   
2011-05-13 06:22   
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/d221ad9e329e [^]

Maturity status: Test
(0037374)
adrianromero   
2011-05-24 12:41   
Verified