Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007141Openbravo ERP07. Sales managementpublic2009-01-26 17:522009-03-18 11:02
Reporternetworkb 
Assigned Torafaroda 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target Version2.40Fixed in Versionpi 
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
Summary0007141: Sales Invoice Dimensional Report doesn't group by business partner when sorting.
DescriptionWhen you execute Sales Invoice Dimensional Report choosing "Sort By Ascending/Descending Amount" results appear sorted but they don't appear grouped.
(It works properly when executing with "sort standard")
Steps To Reproduce1. Go to Sales Management || Analysis Tools || Sales Invoice Dimensional Report
2. Set From Date and To Date
3. Dimensions: choose Business Partner
4. Sort: choose Ascending or Descending
5. View Results
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00071922.40 closed rafaroda Sales Invoice Dimensional Report doesn't group by business partner when sorting. 
depends on backport 0007255 closed rafaroda Sales Invoice Dimensional Report doesn't group by business partner when sorting. 
related to defect 00072182.40 closed gmauleon Dimensional Reports doesn't group propertly  
Attached Filespng SalesInvoiceDimensional.png (42,992) 2009-01-28 15:33
https://issues.openbravo.com/file_download.php?file_id=755&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2009-01-26 17:52networkbNew Issue
2009-01-26 17:52networkbAssigned To => rafaroda
2009-01-26 17:52networkbOBNetwork customer => Yes
2009-01-26 17:52networkbRegression testing => No
2009-01-28 13:05rafarodaStatusnew => scheduled
2009-01-28 13:05rafarodafix_in_branch => trunk
2009-01-28 15:33rafarodaFile Added: SalesInvoiceDimensional.png
2009-01-29 15:13gmauleonRelationship addedrelated to 0007218
2009-01-29 17:39svnbotCheckin
2009-01-29 17:39svnbotNote Added: 0012844
2009-01-29 17:39svnbotStatusscheduled => resolved
2009-01-29 17:39svnbotResolutionopen => fixed
2009-01-29 17:39svnbotsvn_revision => 12505
2009-01-30 11:09rafarodaRelationship addeddepends on 0007255
2009-02-23 08:14sureshbabuStatusresolved => closed
2009-02-23 08:14sureshbabuNote Added: 0013892
2009-02-23 08:14sureshbabuFixed in Version => trunk
2009-03-18 11:02anonymoussf_bug_id0 => 2691369

Notes
(0012844)
svnbot   
2009-01-29 17:39   
Repository: openbravo
Revision: 12505
Author: rafaroda
Date: 2009-01-29 17:39:03 +0100 (Thu, 29 Jan 2009)

Fixes bug 0007141 Removed un-needed UOMSYMBOL from SELECT and GROUP BY since the cut by UOM is already done when showing product dimension.

---
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml
---

https://dev.openbravo.com/websvn/openbravo/?rev=12505&sc=1 [^]
(0013892)
sureshbabu   
2009-02-23 08:14   
Retested in context http://79.125.56.185/openbravotrunk [^]