Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0027488 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Modules] Payment Aging Balance Report | major | always | 2014-08-28 10:04 | 2014-10-15 18:15 | |||
Reporter | maite | View Status | public | |||||
Assigned To | fsoto82 | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | pi | Fixed in SCM revision | d8e87dec85b3 | |||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Regression date | ||||||||
Regression introduced by commit | ||||||||
Regression level | ||||||||
Review Assigned To | vmromanos | |||||||
Regression introduced in release | ||||||||
Summary | 0027488: "Error evaluation expression" SUMDOUBTFULTOTAL when running report | |||||||
Description | In 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 Reproduce | Launch report where variable $V{SUMDOUBTFULTOTAL} is null or $V{SUMNETTOTAL} is zero | |||||||
Proposed Solution | Expressions 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")) | |||||||
Tags | No tags attached. | |||||||
Attached Files | 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 |