Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

2

How to sum records in a tree view?

By
tvaughan
on 12/2/13, 9:25 PM 8,987 views

I added a Tax Description/Account line item in an invoice. I added the field to the tree view by enabling developer mode, editing the view, and adding an entry in the XML for the line item. This is not a module I developed. I'd like to display the sum of the amounts, but no matter what I try I only seem able to display the number of line items as shown in this screenshot: dl.dropboxusercontent.com/u/174789/screenshot.png. In this screenshot there is only one line item, but there could be more.

How can I display the total of the line item values instead of the number of records in the database? Thanks.

Edit: Here are two more screenshots. I created a one2many field in the admin dashboard: dl.dropboxusercontent.com/u/174789/newfield.png. This is the line item entry I made in the invoice: dl.dropboxusercontent.com/u/174789/invoice.png. The field is included in the tree view like: <field name="x_FlourTaxAmount" sum="Flour Tax Total"/>. I did not create a module. I did not add a .py or .xml.

Edit: This is what we came up with. Now that we understand the solution a little better some variables need to be renamed, otherwise this works.

from openerp.osv import fields, osv

class AAA(osv.osv):
    _inherit = 'account.invoice'

    def get_tax_total(self, cr, uid, ids, field, arg, context=None, line_name=None):
        #~ import ipdb;ipdb.set_trace();
        res = {}
        for order in self.browse(cr, uid, ids, context=context):
            res[order.id] = {
                'flour_tax_total': 0,
            }
            val = 0
            for line in order.flour_tax:
        if line.name.startswith(line_name):
                    val += line.tax_amount
            res[order.id] = val
        return res

    def get_flour_tax_total(*args, **kwargs):
    kwargs["line_name"] = "Harina"
        return get_tax_total(*args, **kwargs)

    _columns = {
        'flour_tax': fields.one2many('account.invoice.tax', 'invoice_id', 'Flour Tax Amount'),
        'flour_tax_total': fields.function(get_flour_tax_total, type='float', string='Flour Tax Total'),
    }

    _defaults ={
        'flour_tax': 13,
        'flour_tax_total': 42,
    }

AAA()

In the screenshot, I can see the amount 5000.00 on top and at very bottom. So at the very bottom amount is total of all the values of field Subtotal. You can do it same for line item values but it should be type of float instead of character. Then you can achieve total of line item at the very bottom.

Acespritech
on 12/3/13, 1:01 AM
2
PT SIVI
On 12/3/13, 4:53 AM

You should add one more field.

I presume you already have this is your file.py :

' tax_line *(or whatever)*' : fields.one2many('tax.line*(or whatever)*', 'tax_line_ids*(or whatever)*', 'Flour Tax Amount'),

You should add one more field in your file.py :

'tax_line_sum':fields.function(amount_all,type='integer',string='Total Amount'),

and

 def amount_all(self, cr, uid, ids, field, arg, context=None):
        #~ import ipdb;ipdb.set_trace();
        res = {}
        for order in self.browse(cr, uid, ids, context=context):
            res[order.id] = {
                'tax_line_sum': 0,
            }
            val = 0
            for line in order.tax_line:
                val += line.tax_line_amount
            res[order.id] = val
        return res

And don't forget to add this in your .xml:

<field name="tax_line_sum" sum='Total Tax'/>

Hope it works

Great. Thank you for your reply. Please see my edit above. I have not created a new Python module. I did this through the admin. I'll try your approach, but is there a way I can do this entirely within the admin dashboard? Thanks!

tvaughan
on 12/3/13, 8:20 AM

As far as I know, we are unable to create functional field directly from Web-UI which you will need it for sure. It was also stated here http://stackoverflow.com/questions/18058038/create-a-functional-field-in-openerp-via-web-ui.

Your approach by writing this line one .xml: ' <field name="x_FlourTaxAmount" sum="Flour Tax Total"/>' is incorrect, I presume. Because x_FlourTaxAmount field type is one2many which is unable to sum.

The best that I can suggest to display your total amount of Tax is inside your Form View (not Tree View) by adding this to your xml:

http://bit.ly/1cWsGyu

PT SIVI
on 12/3/13, 10:02 AM

Thanks a lot @fahreza! You definitely pointed us in the right direction.

tvaughan
on 12/3/13, 10:54 AM
0
tvaughan
On 12/3/13, 10:59 AM

Here's the version that worked for us. Now that we understand the solution a little better some variables need to be renamed, otherwise this works.

from openerp.osv import fields, osv

class AAA(osv.osv):
    _inherit = 'account.invoice'

    def get_tax_total(self, cr, uid, ids, field, arg, context=None, line_name=None):
        #~ import ipdb;ipdb.set_trace();
        res = {}
        for order in self.browse(cr, uid, ids, context=context):
            res[order.id] = {
                'flour_tax_total': 0,
            }
            val = 0
            for line in order.flour_tax:
        if line.name.startswith(line_name):
                    val += line.tax_amount
            res[order.id] = val
        return res

    def get_flour_tax_total(*args, **kwargs):
    kwargs["line_name"] = "Harina"
        return get_tax_total(*args, **kwargs)

    _columns = {
        'flour_tax': fields.one2many('account.invoice.tax', 'invoice_id', 'Flour Tax Amount'),
        'flour_tax_total': fields.function(get_flour_tax_total, type='float', string='Flour Tax Total'),
    }

    _defaults ={
        'flour_tax': 13,
        'flour_tax_total': 42,
    }

AAA()

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 12/2/13, 9:25 PM
Seen: 8987 times
Last updated: 5/29/15, 12:26 PM