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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0017122
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajorhave not tried2011-05-11 17:032011-05-24 12:41
ReporterAinhoaPagolaView Statuspublic 
Assigned ToAinhoaPagola 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision08a220fdf2ea
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0017122: 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>

                  
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00162142.50MP28 closedAinhoaPagola There are errors in General Ledger report (excel) with long numbers 
depends on backport 0017123 closedAinhoaPagola General Ledger Report in XLS format gets Strings instead of numbers 
blocks defect 00163092.50MP29 closedadrianromero General Ledger Journal in XLS format , the format of numbers are not correct 

-  Notes
(0036704)
hgbot (developer)
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 (developer)
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 (manager)
2011-05-24 12:41

 Verified

- Issue History
Date Modified Username Field Change
2011-05-11 17:03 AinhoaPagola New Issue
2011-05-11 17:03 AinhoaPagola Assigned To => AinhoaPagola
2011-05-11 17:03 AinhoaPagola Modules => Core
2011-05-11 17:03 AinhoaPagola Status new => scheduled
2011-05-11 17:03 AinhoaPagola fix_in_branch => pi
2011-05-11 17:54 AinhoaPagola Relationship added related to 0016214
2011-05-12 09:14 hgbot Checkin
2011-05-12 09:14 hgbot Note Added: 0036704
2011-05-12 09:14 hgbot Status scheduled => resolved
2011-05-12 09:14 hgbot Resolution open => fixed
2011-05-12 09:14 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/08a220fdf2eaccc01044dc1e7428bdc444bd1454 [^]
2011-05-13 06:22 hudsonbot Checkin
2011-05-13 06:22 hudsonbot Note Added: 0036930
2011-05-13 11:08 AinhoaPagola Relationship added blocks 0016309
2011-05-24 12:41 adrianromero Note Added: 0037374
2011-05-24 12:41 adrianromero Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker