Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015797Openbravo ERP07. Sales managementpublic2011-01-27 13:282011-03-01 00:00
Reporteradrianromero 
Assigned Toadrianromero 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50MP27 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015797: 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
blocks backport 00153072.50MP26 closed adrianromero Quantity column in Sales and Shipments Dimensional Report 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-01-27 13:28adrianromeroNew Issue
2011-01-27 13:28adrianromeroAssigned To => adrianromero
2011-01-27 13:28adrianromeroModules => Core
2011-01-27 13:28adrianromeroIssue generated from0015307
2011-01-27 13:28adrianromeroRelationship addedblocks 0015307
2011-01-27 13:29adrianromeroStatusnew => scheduled
2011-01-27 13:29adrianromerofix_in_branch => pi
2011-02-03 12:28hgbotCheckin
2011-02-03 12:28hgbotNote Added: 0034029
2011-02-03 12:28hgbotStatusscheduled => resolved
2011-02-03 12:28hgbotResolutionopen => fixed
2011-02-03 12:28hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9d26e80ed49c9a4f4f6df1cc4a87b392cb34d78e [^]
2011-02-03 12:31adrianromeroNote Added: 0034031
2011-02-28 16:21maiteNote Added: 0034429
2011-02-28 16:21maiteStatusresolved => closed
2011-02-28 16:21maiteFixed in Version => 2.50MP27
2011-03-01 00:00anonymoussf_bug_id0 => 3195606

Notes
(0034029)
hgbot   
2011-02-03 12:28   
Repository: erp/devel/pi
Changeset: 9d26e80ed49c9a4f4f6df1cc4a87b392cb34d78e
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Feb 03 12:25:05 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/9d26e80ed49c9a4f4f6df1cc4a87b392cb34d78e [^]

Fixes issue 0015797: 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
---
(0034031)
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
(0034429)
maite   
2011-02-28 16:21   
verified