Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029858Openbravo ERPA. Platformpublic2015-05-12 18:292017-11-21 17:16
Reporterumartirena 
Assigned Toinigosanchez 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029858: Summary functions don't work on tabs defined based on HQL Query Tables
DescriptionSummary functions don't work on tabs defined based on HQL Query Tables
Steps To ReproduceInstall the following module:
 
https://code.openbravo.com/erp/mods/org.openbravo.costing.explaincostadjustments [^] [^]

As F&B Group Admin:

* Create a product
* Add a purchase and sales price list. 10 for both
* Enter a cost in the costing tab:
 - Org: F&B España
 - Cost Type: Average
 - Cost: 5
 - Starting Date: 01/01/2014
 - Ending Date: 31/12/9999
 - Warehouse: Empty

* Create a shipment dated on 25/01/2015 for that product
* Complete the shipment.

* Create a receipt dated on 15/01/2015 (backdated transaction) again for that product
* Complete the receipt.

* In Process request: Launch Costing Background process.

* Go back to Product window and select the product.
* Go to Costing Tab.
* Go to Costing Transactions tab.
* Right click on Transaction Cost column. Set Sum summary function.
* Realize that the summary is not working properly. Have a look on attached screenshot.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 0034324 closed inigosanchez Summary function does not function for WIndow's created using hql tables. 
duplicate of design defect 0034635 new Triage Platform Base Add ability to use Summary Functions in tabs based on HQL Query. 
Attached Filespng Summary Function.png (47,371) 2015-05-12 18:38
https://issues.openbravo.com/file_download.php?file_id=8078&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2015-05-12 18:29umartirenaNew Issue
2015-05-12 18:29umartirenaAssigned To => platform
2015-05-12 18:29umartirenaModules => Core
2015-05-12 18:29umartirenaTriggers an Emergency Pack => No
2015-05-12 18:38umartirenaFile Added: Summary Function.png
2015-11-06 12:24alostaleStatusnew => acknowledged
2015-11-06 12:25alostalePriorityhigh => normal
2015-11-06 12:25alostaleSeveritymajor => minor
2017-07-04 11:24ngarciaRelationship addedduplicate of 0034324
2017-11-21 17:15inigosanchezStatusacknowledged => scheduled
2017-11-21 17:15inigosanchezAssigned Toplatform => inigosanchez
2017-11-21 17:16inigosanchezReview Assigned To => alostale
2017-11-21 17:16inigosanchezRelationship addedduplicate of 0034635
2017-11-21 17:16inigosanchezNote Added: 0100657
2017-11-21 17:16inigosanchezStatusscheduled => closed
2017-11-21 17:16inigosanchezResolutionopen => duplicate

Notes
(0100657)
inigosanchez   
2017-11-21 17:16   
Since the issue 0034324, summary functions are disabled on tabs defined based on HQL Query Tables. Also it was reported a design defect issue 0034635 in order to add the ability to use Summary Functions in tabs based on HQL Query.