This question has been flagged
2 Replies
40984 Views
Avatar
tvaughan

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()
Avatar
Discard
Acespritech Solutions Private Limited

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.

Avatar
PT SIVI
Best Answer

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

Avatar
Discard
tvaughan
Author

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!

PT SIVI

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

tvaughan
Author

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

Avatar
tvaughan
Author Best Answer

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()
Avatar
Discard