How to update many 2 many field.

Question

Hi, I am using Odoo 14 I am trying to update a many 2 many field from Server Action, but it seems Odoo is protecting itself because it gets back in a second to the original values. I am trying to link an invoice to as sale order, so I am using:
record.write({'invoice_ids': [(3, 456)]}) #456 is the record of the invoice
raise Warning(record.invoice_ids) The warning shows that the new Id has been appended to the current values, but if I check again in the next second, the values get back to the or

Oscar del Rio · Answer

Hi Jainesh Shah,
Thank you for your response. I tried what you suggest, but I receive the following User Errror: "You cannot delete an entry which has been posted once."
So I think that what this code tries to do is delete the records, maybe there is my error. I don't want to delete nor create records. I just want to create a relationship between the current record with another record throught its many2many field.
Explicitly, what I want to do is add two existing invoices to an existing sale ord

Jainesh Shah(Aktiv Software) · Answer

Hello Oscar del Rio,
(3,id) will remove record from field but not permanently so if you want to remove this record permanently you can use (2,id) and (4,id) to add existing record in many2many field

Please refer below link for better understanding.
https://www.odoo.com/documentation/15.0/developer/reference/backend/orm.html?highlight=many2many#odoo.fields.Many2many [1]
Thanks & Regards,
Email: odoo@aktivsoftware.com
Skype: kalpeshmaheshwari

[1] https://www.odoo.com/documentation/15.0/develope

Related Posts	Replies	Views
generating invoice from sale order in odoo 14 Solved python invoice xmlrpc sale.order	1 Oct 22	3888
python code needed for scheduled action python actions	2 May 23	6201
Create invoice from sales order using xml-rpc (python) invoice sale.order	1 Oct 22	5044
Different Sale Order and Invoice description for one Product invoice sale.order	1 Feb 17	3851
Different sales orders on a single invoice Solved invoice sale.order	2 Jan 17	7976

This question has been flagged

Enjoying the discussion? Don't just read, join in!