Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0015307Openbravo ERP07. Sales managementpublic2010-11-26 15:232011-02-28 16:17
networkb 
adrianromero 
normalminoralways
closedfixed 
5
2.50MP23 
2.50MP262.50MP27 
Core
No
0015307: Quantity column in Sales and Shipments Dimensional Report
Sales and Shipments Dimensional Report do not show the correct value of Quantity column.
1) 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.
No tags attached.
depends on defect 0015797 closed adrianromero Quantity column in Sales and Shipments Dimensional Report 
Issue History
2010-11-26 15:23networkbNew Issue
2010-11-26 15:23networkbAssigned To => adrianromero
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