← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 392045] Re: XML "Sum" function summarizes only "visible" rows

 

The KDE client handles this nicely: if the query returns less than 80
records (one page*) it automatically shows the sum; else it shows an
"update totals" hyperlink-like caption.


* Koo does dynamic paging of records, so there are no "next"/"previous" buttons on lists.

-- 
XML "Sum" function summarizes only "visible" rows
https://bugs.launchpad.net/bugs/392045
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP OpenObject.

Status in OpenObject Server: Incomplete
Status in OpenObject Server trunk series: Incomplete

Bug description:
I'ts sort of a critical wishlist to provide "save" usage of the system.

the XML "sum" functions sum up ONLY the visible rows.

if more than 80 (default) rows are availabe the "sum" only shows the sum of the first 80 rows , after forward the sum of the next  set of rows etc

the fields in 
./addons/account/account_view.xml
./addons/account_followup/followup_view.xml
are called "Total Debit/Credit" suggesting it's a Total, but might only be a "Subtotal" for the displayed rows.

IMHO it is very important to remove this sort of sum and replace it with "Sums" representing the Sums of the context.

Example Partner -> Receivables and Payables 
The accountant needs to see the balance (which I added in https://bugs.launchpad.net/openobject-addons/+bug/358584) 

For now I'd strongly suggest to disable the display of "sum's" unless all records are displayed.
To display all records I suggest a button "Display all Records" instead of fiddling around increasing the limit to # records

BTW I like the idea that the "sum" function can be used to add up selected/marked records.