How to I can get value of total_avoiced to use calculate for a new field at res.partner?

Question

class ResPartner(models.Model):
_inherit = 'res.partner'
type_customer = fields.Selection([('normal','Normal'), ('gold', 'Gold')], string='Type customer', default=type_cus[0][0])
@api.depends('total_invoiced')
def _compute_type_customer(self):
for rec in self:
if rec.total_invoiced > 1000:
rec.type_customer = 'Gold'
else:
rec.type_customer = 'Normal'

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
To change the value of the field type_customer according to the total_invoice amount.Updated the code like this:
class ResPartner(models.Model):
_inherit = 'res.partner'
type_customer = fields.Selection([('normal', 'Normal'), ('gold', 'Gold')], string='Type customer', compute='_compute_type_customer')
def _compute_type_customer(self):
for rec in self:
total_invoiced = sum(rec.env['account.move'].browse(rec.id).mapped('amount_total_signed'))
if total_invoiced > 1000:
rec.type_customer = 'Gold

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
To get the total invoiced amount of the customer, you can read it from account.move.line [1]  using the search orm with proper domain in search function.
domain = []
self.env['account.move.line'].search(domain)

Thanks

[1] https://account.move.line

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Cannot make Sales Quotation to one Customer sales	2 marrask. 25	363
How to allow quotation requests (RFQ) from the eCommerce instead of direct sales sales	1 lokak. 25	837
Products Image sales	2 lokak. 25	440
Edit the Sign & accept quotation button sales	0 lokak. 25	1362
SALES ORDER - UncaughtPromiseError > OwlError Uncaught Promise > An error occured in the owl lifecycle (see this Error's "cause" property) sales	3 lokak. 25	970

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!