0029104: Product category hierarchy is not taken into account in dimensional reports

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0029104

Openbravo ERP

02. Master data management

public

2015-03-02 17:30

2015-03-03 17:44

Reporter

caristu

Assigned To

Sandrahuguet

Priority

high

Severity

minor

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

Target Version

Fixed in Version

3.0PR15Q2

Merge Request Status

Review Assigned To

jonalegriaesarte

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

34733

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0029104: Product category hierarchy is not taken into account in dimensional reports

Description

Product category hierarchy is not taken into account in dimensional reports

Steps To Reproduce

1) Go to the [Product Category] window. Create a new product category:
  - Search Key: Main
  - Name: Main
  - Summary Level: yes
2) Put the "Water" category as child of the "Main" category
3) Go to the [Goods Receipt] window. Create a new record in the header with date of today.
4) Navigate to the [Lines] window, create a new record:
   - Product: Agua sin Gas 1L
   - Movement Quantity: 1
5) Complete the goods receipt
6) Open the [Goods Receipt Dimensional] report. Execute with the following paramenters:
   - From Date: today
   - To date: today
   - Product Group: Water
   - Dimensions: any
  Notice that the receipt created in step 4) is shown in the report correctly
7) Execute the report again, but changing the product group. Use "Main" instead and execute it. No records are found.

Only the first parent category of the product is taken into account. The same behavior happens with the rest of the dimensional reports like for example "Sales Invoice Dimensional Report"

Proposed Solution

Additional Information