Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015307Openbravo ERP07. Sales managementpublic2010-11-26 15:232011-02-28 16:17
Reporternetworkb 
Assigned Toadrianromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP23 
Target Version2.50MP26Fixed in Version2.50MP27 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015307: Quantity column in Sales and Shipments Dimensional Report
DescriptionSales and Shipments Dimensional Report do not show the correct value of Quantity column.
Steps To Reproduce1) Go to Sales Management || Analysis Tools || Sales Dimensional Report || Sales Dimensional Report
2) Select a date interval where there are transactions
3) In dimensions, first add "Product" and then "Documentno"
4) Generate the report, and see that Quantity column for a certain product is not the accumulative value of the different sales orders.

Note: the same happens with Shipments Dimensional Report.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0015797 closed adrianromero Quantity column in Sales and Shipments Dimensional Report 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-11-26 15:23networkbNew Issue
2010-11-26 15:23networkbAssigned To => adrianromero
2010-11-26 15:23networkbOBNetwork customer => Yes
2010-11-26 15:26networkbIssue Monitored: emartinez
2011-01-27 13:28adrianromeroStatusnew => scheduled
2011-01-27 13:28adrianromeroTypedefect => backport
2011-01-27 13:28adrianromeroIssue cloned0015797
2011-01-27 13:28adrianromeroRelationship addeddepends on 0015797
2011-02-03 12:30hgbotCheckin
2011-02-03 12:30hgbotNote Added: 0034030
2011-02-03 12:30hgbotStatusscheduled => resolved
2011-02-03 12:30hgbotResolutionopen => fixed
2011-02-03 12:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/8ea431427f3376b6ccb77569623d5f9ecc63c890 [^]
2011-02-03 12:31adrianromeroNote Added: 0034032
2011-02-28 16:17maiteNote Added: 0034427
2011-02-28 16:17maiteStatusresolved => closed
2011-02-28 16:17maiteFixed in Version => 2.50MP27

Notes
(0034030)
hgbot   
2011-02-03 12:30   
Repository: erp/stable/2.50
Changeset: 8ea431427f3376b6ccb77569623d5f9ecc63c890
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Feb 03 12:28:54 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/8ea431427f3376b6ccb77569623d5f9ecc63c890 [^]

Fixes issue 0015307: Quantity column in Sales and Shipments Dimensional Report
It has been fixed the jasper reports template for all dimensional reports non comparatives to make the quantity of group 1 to sum by level 1. It was incorrectly grouping by level 5

---
M src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml
---
(0034032)
adrianromero   
2011-02-03 12:31   
* Testing the issue

Kindly follow the steps to test and verify now that the quantity of level 1 is summing as expected.

Verify also some other non comparative dimensional reports.

* Other areas affected

No other areas affected apart from non comparative dimensional reports
(0034427)
maite   
2011-02-28 16:17   
verified