Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037781Openbravo ERP07. Sales managementpublic2018-01-30 11:152018-02-01 10:00
Reporterpramodkumar 
Assigned Tocollazoandy4 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionmain 
Target Version3.0PR18Q1Fixed in Version3.0PR18Q1 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037781: Sales Invoice Dimensional Report in Excel - error 0/0
DescriptionIf Sales Invoice Dimensional report is executed in excel (pdf is working fine) with invoices that have a total amount of zero an error is raising:


24df6f05 2018-01-26 13:45:58,345 [ajp-bio-127.0.0.1-8009-exec-1] ERROR org.openbravo.erpCommon.ad_reports.ReportInvoiceCustomerDimensionalAnalysesJR - Error
captured:
javax.servlet.ServletException: Error evaluating expression :
Source text : $V{totalProfit}.divide($V{totalAmt}, 10, BigDecimal.ROUND_HALF_UP).multiply( new BigDecimal("100") ).multiply(new BigDecimal($V{totalProfit}.signum()))
at org.openbravo.base.secureApp.HttpSecureAppServlet.renderJR(HttpSecureAppServlet.java:1306)
at org.openbravo.base.secureApp.HttpSecureAppServlet.renderJR(HttpSecureAppServlet.java:1205)
at org.openbravo.erpCommon.ad_reports.ReportInvoiceCustomerDimensionalAnalysesJR.printPageHtml(ReportInvoiceCustomerDimensionalAnalysesJR.java:1036)
at org.openbravo.erpCommon.ad_reports.ReportInvoiceCustomerDimensionalAnalysesJR.doPost(ReportInvoiceCustomerDimensionalAnalysesJR.java:299)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:228)
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:462)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
Steps To Reproduce1.Create any sales invoices with zero amount
2.Open sales invoice dimensional reports and pass the minimum parameter to get the report corresponding to customers.
3.Select the excel format report(Pdf working fine).

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0037766 closed collazoandy4 Sales Invoice Dimensional Report in Excel - error 0/0 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-01-30 23:27collazoandy4Typedefect => backport
2018-01-30 23:27collazoandy4Target Version => 3.0PR18Q1
2018-02-01 09:59dmiguelezNote Added: 0102110
2018-02-01 09:59dmiguelezStatusscheduled => resolved
2018-02-01 09:59dmiguelezFixed in Version => 3.0PR18Q1
2018-02-01 09:59dmiguelezFixed in SCM revision => https://code.openbravo.com/erp/backports/3.0PR18Q1/rev/d9b6eab2cbe943f9a4cb454423211ebfcffb2d58 [^]
2018-02-01 09:59dmiguelezResolutionopen => fixed
2018-02-01 10:00dmiguelezReview Assigned To => dmiguelez
2018-02-01 10:00dmiguelezNote Added: 0102111
2018-02-01 10:00dmiguelezStatusresolved => closed

Notes
(0102110)
dmiguelez   
2018-02-01 09:59   
Fixed by commits:
https://code.openbravo.com/erp/backports/3.0PR18Q1/rev/05baa2c353ce551b12cc59de8288ea62c6ee6614 [^]
https://code.openbravo.com/erp/backports/3.0PR18Q1/rev/d9b6eab2cbe943f9a4cb454423211ebfcffb2d58 [^]
(0102111)
dmiguelez   
2018-02-01 10:00   
Code Review + Testing Ok