Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038816Openbravo ERPZ. Otherspublic2018-06-22 13:382018-08-08 13:06
Reporteranderaranguren 
Assigned Tocollazoandy4 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q4 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0038816: Sales Invoice Dimensional Report of a Product Category checked as summary level does not show data.
DescriptionSales Invoice Dimensional Report of a Product Category checked as summary level does not show data.
Steps To Reproduce-Log in the backoffice
-Go to Product Category window and ensure there is a summary level category with some categories below it.
- Go to Sales Invoice Dimensional Report window
- Select in Product Group the summary level checked product category
- Press the HTML Format Button
No data has been found.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0038839 new Triage Omni OMS Reports of a Product Category checked as summary level does not show data. 
Attached Filespng NoData.png (37,319) 2018-06-22 13:38
https://issues.openbravo.com/file_download.php?file_id=11891&type=bug
png

png SalesInvoiceDimReport.png (104,685) 2018-06-22 13:39
https://issues.openbravo.com/file_download.php?file_id=11892&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2018-06-22 13:38anderarangurenNew Issue
2018-06-22 13:38anderarangurenAssigned To => Triage Finance
2018-06-22 13:38anderarangurenFile Added: NoData.png
2018-06-22 13:38anderarangurenWeb browser => Google Chrome
2018-06-22 13:38anderarangurenModules => Core
2018-06-22 13:38anderarangurenResolution time => 1531432800
2018-06-22 13:38anderarangurenTriggers an Emergency Pack => No
2018-06-22 13:39anderarangurenFile Added: SalesInvoiceDimReport.png
2018-06-22 13:54PracticsIssue Monitored: Practics
2018-06-25 08:29SandrahuguetAssigned ToTriage Finance => collazoandy4
2018-06-25 22:18collazoandy4Statusnew => scheduled
2018-06-26 15:58collazoandy4Relationship addedrelated to 0038839
2018-06-26 20:54collazoandy4Note Added: 0105456
2018-07-09 15:59hgbotCheckin
2018-07-09 15:59hgbotNote Added: 0105679
2018-07-09 15:59hgbotStatusscheduled => resolved
2018-07-09 15:59hgbotResolutionopen => fixed
2018-07-09 15:59hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7d1b4e0de850238cf47004b0520ac9f74a006a84 [^]
2018-07-09 16:02SandrahuguetReview Assigned To => Sandrahuguet
2018-07-09 16:02SandrahuguetNote Added: 0105681
2018-07-09 16:02SandrahuguetStatusresolved => closed
2018-07-09 16:02SandrahuguetFixed in Version => 3.0PR18Q4
2018-08-08 13:06hudsonbotCheckin
2018-08-08 13:06hudsonbotNote Added: 0106209

Notes
(0105456)
collazoandy4   
2018-06-26 20:54   
Test Plan
  As F&B International Group Admin Role
    Go to Product Category window and create a new record:
      Search Key/Name: Summary
      Summary Level: Y
      Set Water, Alcoholic and Fruit juice categories under Summary category
    Go to Sales Invoice Dimensional Report and fill the mandatory fields and select Summary as Product Group
      Launch the report in HTML, PDF and XLS formats, check the report shows data
      Set Comparative Report: Y and fill the mandatory fields
      Launch the report in HTML, PDF and XLS formats, check the report shows data
(0105679)
hgbot   
2018-07-09 15:59   
Repository: erp/devel/pi
Changeset: 7d1b4e0de850238cf47004b0520ac9f74a006a84
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Tue Jun 26 12:18:58 2018 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/7d1b4e0de850238cf47004b0520ac9f74a006a84 [^]

Fixes issue 38816:Sales Invoice Dimensional Report of a Product Category checked
as summary level does not show data.

If the product category checked as summary with some categories below it is selected
the report doesn't show data because does not take into account the hierarchy

The Report take into account the product category hierarchy to filter the categories

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeExtendedJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
M src/org/openbravo/erpCommon/businessUtility/Tree.java
M src/org/openbravo/erpCommon/businessUtility/Tree_data.xsql
---
(0105681)
Sandrahuguet   
2018-07-09 16:02   
Code review + testing OK
(0106209)
hudsonbot   
2018-08-08 13:06   
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/bfd7a414183a [^]
Maturity status: Test