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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0027488
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Payment Aging Balance Reportmajoralways2014-08-28 10:042014-10-15 18:15
ReportermaiteView Statuspublic 
Assigned Tofsoto82 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisiond8e87dec85b3
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned Tovmromanos
Regression introduced in release
Summary

0027488: "Error evaluation expression" SUMDOUBTFULTOTAL when running report

DescriptionIn that case, problem is with expression
$V{SUMDOUBTFULTOTAL}.divide( $V{SUMNETTOTAL}, 5, RoundingMode.HALF_UP ).multiply(new BigDecimal("100"))
because, under some circumstances, variable $V{SUMDOUBTFULTOTAL} is null or $V{SUMNETTOTAL} is zero
Steps To ReproduceLaunch report where variable $V{SUMDOUBTFULTOTAL} is null or $V{SUMNETTOTAL} is zero
Proposed SolutionExpressions containing SUMDOUBTFULTOTAL need to be reviewed verifying if variables are null or zero to properly handle situation in AgingScheduleDetailHTML.jrxml , AgingScheduleDetailPDFDoubtfulDebt.jrxml and AgingScheduleDetailXLSDoubtfulDebt.jrxml.

Expression needs to be changed to:

$V{SUMDOUBTFULTOTAL}.divide( $V{SUMNETTOTAL}.doubleValue() == 0 ? new BigDecimal("1"):$V{SUMNETTOTAL}, 5, RoundingMode.HALF_UP ).multiply(new BigDecimal("100"))

TagsNo tags attached.
Attached Filesdiff file icon 27488.diff [^] (3,074 bytes) 2014-08-28 10:16 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0070975)
hgbot (developer)
2014-10-15 17:57

 Repository: erp/mods/org.openbravo.agingbalance
Changeset: d8e87dec85b308fbbbc24ca04582ef5af5763fb7
Author: Fernando Soto <fernando.soto <at> peoplewalking.com>
Date: Thu Oct 09 00:21:37 2014 -0500
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/d8e87dec85b308fbbbc24ca04582ef5af5763fb7 [^]

Fixed bug 27488: "Error evaluation expression" SUMDOUBTFULTOTAL when run report

Fixed reports to void division by 0.

---
M src/org/openbravo/agingbalance/ad_reports/AgingScheduleDetailHTML.jrxml
M src/org/openbravo/agingbalance/ad_reports/AgingScheduleDetailPDFDoubtfulDebt.jrxml
M src/org/openbravo/agingbalance/ad_reports/AgingScheduleDetailXLSDoubtfulDebt.jrxml
---
(0070976)
vmromanos (manager)
2014-10-15 17:58

 Code review OK
(0070977)
vmromanos (manager)
2014-10-15 18:15

 Released new module version 3.1.36

- Issue History
Date Modified Username Field Change
2014-08-28 10:04 maite New Issue
2014-08-28 10:04 maite Assigned To => dmiguelez
2014-08-28 10:09 maite Issue Monitored: networkb
2014-08-28 10:16 maite File Added: 27488.diff
2014-09-01 16:29 jonalegriaesarte Resolution time => 1411855200
2014-10-03 05:47 fsoto82 Status new => scheduled
2014-10-03 05:47 fsoto82 Assigned To dmiguelez => fsoto82
2014-10-03 05:47 fsoto82 fix_in_branch => pi
2014-10-15 17:57 hgbot Checkin
2014-10-15 17:57 hgbot Note Added: 0070975
2014-10-15 17:57 hgbot Status scheduled => resolved
2014-10-15 17:57 hgbot Resolution open => fixed
2014-10-15 17:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/d8e87dec85b308fbbbc24ca04582ef5af5763fb7 [^]
2014-10-15 17:58 vmromanos Review Assigned To => vmromanos
2014-10-15 17:58 vmromanos Note Added: 0070976
2014-10-15 17:58 vmromanos Status resolved => closed
2014-10-15 18:15 vmromanos Note Added: 0070977

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker