Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0007219 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 07. Sales management | major | always | 2009-01-29 11:47 | 2009-03-04 13:38 | |||
| Reporter | gmauleon | View Status | public | |||||
| Assigned To | gmauleon | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.40MP3 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 12494 | |||
| Projection | none | ETA | none | Target Version | 2.40 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0007219: Dimensional Reports doesn't group propertly | |||||||
| Description | When you execute dimensional Reports choosing "Sort By Ascending/Descending Amount" results appear sorted but they don't appear grouped. (It works properly when executing with "sort standard") These Dimensional reports are failing -Sales Dimensional Report -Shipments Dimensional Report -Sales Order Returns Dimensional Report -Purchase Dimensional Report -Material Receipts Dimensional Report -Purchase Invoice Dimensional Report | |||||||
| Steps To Reproduce | 1.-Select one of the dimensional reports commented 2. Set From Date and To Date 3. Dimensions: choose Business Partner 4. Sort: choose Ascending or Descending 5. View Results | |||||||
| Proposed Solution | -Avoid the usage of UOMSYMBOL in the SQl querys. Some result are duplicated because the usage of this column to order the result. | |||||||
| Tags | comsup_sprint5 | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0012822) svnbot (viewer) 2009-01-29 15:15 |
Repository: openbravo Revision: 12480 Author: gmauleon Date: 2009-01-29 15:15:11 +0100 (Thu, 29 Jan 2009) Fixes 0007219 Removed un-needed UOMSYMBOL from SELECT and GROUP BY since the cut by UOM is already done when showing product dimension. --- U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR.java U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR_data.xsql U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesJR.java U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesJR_data.xsql U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR.java U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR_data.xsql U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalyses.java U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalyses_data.xsql U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR.java U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR_data.xsql U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJR.java U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJR_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=12480&sc=1 [^] |
|
(0012836) svnbot (viewer) 2009-01-29 16:57 |
Repository: openbravo Revision: 12494 Author: gmauleon Date: 2009-01-29 16:57:12 +0100 (Thu, 29 Jan 2009) related to issue 7219 Dimensional Reports doesn't group propertly --- U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalComparative.jrxml U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalNoComparative.jrxml U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/WeightDimensionalComparative.jrxml U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml --- https://dev.openbravo.com/websvn/openbravo/?rev=12494&sc=1 [^] |
|
(0014386) sureshbabu (viewer) 2009-03-04 13:38 |
http://79.125.57.19/openbravo240mp3oracle [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-01-29 12:04 | rafaroda | Type | defect => backport |
| 2009-01-29 12:04 | rafaroda | fix_in_branch | => 2.40 |
| 2009-01-29 15:12 | gmauleon | Tag Attached: comsup_sprint5 | |
| 2009-01-29 15:12 | gmauleon | Tag Attached: Messages | |
| 2009-01-29 15:12 | gmauleon | Tag Detached: Messages | |
| 2009-01-29 15:13 | gmauleon | Relationship added | related to 0007192 |
| 2009-01-29 15:15 | svnbot | Checkin | |
| 2009-01-29 15:15 | svnbot | Note Added: 0012822 | |
| 2009-01-29 15:15 | svnbot | Status | scheduled => resolved |
| 2009-01-29 15:15 | svnbot | Resolution | open => fixed |
| 2009-01-29 15:15 | svnbot | svn_revision | => 12480 |
| 2009-01-29 16:57 | svnbot | Checkin | |
| 2009-01-29 16:57 | svnbot | Note Added: 0012836 | |
| 2009-01-29 16:57 | svnbot | svn_revision | 12480 => 12494 |
| 2009-02-11 14:18 | rafaroda | Issue cloned | 0007501 |
| 2009-03-03 17:31 | psarobe | Fixed in Version | => 2.40MP3 |
| 2009-03-04 13:38 | sureshbabu | Status | resolved => closed |
| 2009-03-04 13:38 | sureshbabu | Note Added: 0014386 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |