콘텐츠로 건너뛰기
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
모든 게시물 사용자 배지
태그 (모두 보기)
odoo accounting v14 pos v15
게시판 정보
신고된 질문입니다
2 답글
44481 화면
아바타
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()
아바타
취소
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.

아바타
PT SIVI
베스트 답변

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

아바타
취소
tvaughan
작성자

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
작성자

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

아바타
tvaughan
작성자 베스트 답변

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()
아바타
취소