Hello,

I tried to get the sum of invoices related to sale orders so that it can be available in sale.order.tree view for example. My code is:

from openerp import fields, models, api
 

class AAA(models.Model):
    _inherit = 'sale.order'
    @api.one
    @api.depends('invoice_ids.invoice_line.price_subtotal')
    def _my_amount_total(self):
        total=self.env['account.invoice.line'].search([('invoice_id','in',self.invoice_ids)])
        self.my_amount_total_invoice = sum(item.price_subtotal for item in total)
    my_amount_total_invoice = fields.Float(string="# Sum", compute='_my_amount_total')

AAA()

ButI got the following error

AssertionError: Invalid value account.invoice(1,) in domain term ('invoice_id', 'in', account.invoice(1,))

The problem is with this line:

total=self.env['account.invoice.line'].search([('invoice_id','in',self.invoice_ids)])

Can anyone help me?

Thanks in advance,

Regards