Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0044582Openbravo ERPB. User interfacepublic2020-07-09 13:482020-07-10 07:09
Reportersanti_lozano 
Assigned Toplatform 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutioninvalid 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
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
Summary0044582: Summary function not working on Return From Customer column Total Gross Amount
DescriptionReturn From Customer gets the data from table c_order as a Sales Order but the column on that window Total Gross Amount only has available Count as Summary Function
It is a numeric column and it should have Sum, Avg, Min, Max available not only Count
http://wiki.openbravo.com/wiki/User_Interface_Introduction#Grid_Summaries [^]
Customer needs this tool in order to extract data for analyzing easily
Steps To Reproduce* go to livebuilds latest version
* go to window Return From Customer, on Total Gross Amount column select the dropdown, select Set Summary Function, only Count is available
* if you go to Sales Order more options are available for this column here
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00231943.0MP21 closed mtaal Client class/canvas fields invalid behavior in grid summary 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-07-09 13:48santi_lozanoNew Issue
2020-07-09 13:48santi_lozanoAssigned To => platform
2020-07-09 13:48santi_lozanoModules => Core
2020-07-09 13:48santi_lozanoResolution time => 1596060000
2020-07-09 13:48santi_lozanoTriggers an Emergency Pack => No
2020-07-09 13:50santi_lozanoSummarySummary function not working on Return From Customer => Summary function not working on Return From Customer column Total Gross Amount
2020-07-10 07:09alostaleNote Added: 0121382
2020-07-10 07:09alostaleStatusnew => closed
2020-07-10 07:09alostaleResolutionopen => invalid
2020-07-10 07:09alostaleRelationship addedrelated to 0023194

Notes
(0121382)
alostale   
2020-07-10 07:09   
Total Gross Amount is a canvas field (it has client class OBTruncAddMinusDisplay), this type of fields do not support summary functions.

The reason for this is summary functions need to be computed in backend whereas canvas fields perform data transformations in the browser. Therefore, it would not possible to calculate the correct summary values for them in these cases.