Skip to Content
मेन्यू
This question has been flagged
1 Reply
4381 Views

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

 


Avatar
Discard
Best Answer

self.invoice_ids in new api return a recordset (not a set of ids), see documentation

 

Avatar
Discard
Related Posts Replies Views Activity
0
फ़र॰ 19
3651
0
अक्तू॰ 22
7647
0
अग॰ 22
59
1
जन॰ 19
8406
1
मार्च 15
6352