Cannot update view "sale_report"

Question

Hi all!,
I made a field with a module in sale.report. And now when i want to update a contact with my new field it throws this error, any idea?

File "/opt/odoo13/odoo/odoo/addons/base/models/ir_translation.py", line 558, in create
self.flush()
File "/opt/odoo13/odoo/odoo/models.py", line 5502, in flush
process(self.env[model_name], id_vals)
File "/opt/odoo13/odoo/odoo/models.py", line 5493, in process
recs._write(vals)
File "/opt/odoo13/odoo/odoo/models.py", line 3696, in _write
cr.execute(quer

Pol Lopez Montenegro · Answer

I made a module to try to update the field but i'm getting the same error:

from odoo import _, exceptions, models, api, fields
class ResPartner(models.Model):
_inherit = 'res.partner'
@api.onchange('x_studio_sector')
def _onchange_x_studio_sector(self):
for rec in self:
parentIndustry = rec.industry_id
for child in rec.child_ids:
child.industry_id = parentIndustry

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
The sale.report model is not same as other models, if you check the original code, you can see that it is created using the query by fetching data from sale order line. You have to inherit the query and add the value to it. Please see the sale_margin module and see, how the margin field is inherited and added to the sale.report model.

Thanks

Gerelateerde posts	Antwoorden	Weergaven
Undefined Column in sale.report Opgelost modules python postgresql Odoo13.0 odoo13.0	2 jun. 21	6868
how to add product to sale.subscription order line Opgelost python subscription Odoo13.0 odoo13.0	1 jun. 20	4305
modulo no crea tabla en postgresql odoo 17 python postgresql	2 mei 24	2355
Get first employee check in to the system for specific day odoo 13 python Odoo13.0	1 aug. 21	3110
Adding new state to existing invoice model Opgelost python Odoo13.0	1 apr. 21	4659

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!