Cannot update view "sale_report"

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
Project
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

Cannot update view "sale_report"

views python postgresql Odoo13.0 odoo13.0

2 الردود

5000 أدوات العرض

Pol Lopez Montenegro

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(query, params + [sub_ids])
File "/opt/odoo13/odoo/odoo/sql_db.py", line 173, in wrapper
return f(self, *args, **kwargs)
File "/opt/odoo13/odoo/odoo/sql_db.py", line 250, in execute
res = self._obj.execute(query, params)
psycopg2.errors.ObjectNotInPrerequisiteState: cannot update view "sale_report"
DETAIL: Views containing GROUP BY are not automatically updatable.
HINT: To enable updating the view, provide an INSTEAD OF UPDATE trigger or an unconditional ON UPDATE DO INSTEAD rule.

My field in module:

x_studio_sector = fields.Char(String = "Sector", related='partner_id.industry_id.name', store=True)

Pol Lopez Montenegro

الكاتب

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)

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

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Undefined Column in sale.report تم الحل modules python postgresql Odoo13.0 odoo13.0	2 يونيو 21	6045
how to add product to sale.subscription order line تم الحل python subscription Odoo13.0 odoo13.0	1 يونيو 20	3612
modulo no crea tabla en postgresql odoo 17 python postgresql	2 مايو 24	1648
Get first employee check in to the system for specific day odoo 13 python Odoo13.0	1 أغسطس 21	2419
Adding new state to existing invoice model تم الحل python Odoo13.0	1 أبريل 21	3892

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!