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

CRM
e-Commerce
Contabilidad
Inventario
PoS
Proyectos
MRP

All apps

Todas las publicaciones Personas Insignias

Etiquetas (Ver todo)

odoo accounting v14 pos v15

Acerca de este foro

Ayuda

I have error when I wan edit product in Inventory and POS, relation "sale_report" does not exist

sale.order

1 Responder

3186 Vistas

Edi Rahmadi

Error:

Odoo Server Error

Traceback (most recent call last):

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 936, in __get__

value = record.env.cache.get(record, self)

File "/usr/lib/python3/dist-packages/odoo/api.py", line 960, in get

value = self._data[field][record.id][key]

KeyError: <odoo.api.Environment object at 0x7f7d56772be0>

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 936, in __get__

value = record.env.cache.get(record, self)

File "/usr/lib/python3/dist-packages/odoo/api.py", line 960, in get

value = self._data[field][record.id][key]

KeyError: <odoo.api.Environment object at 0x7f7d56772be0>

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/usr/lib/python3/dist-packages/odoo/http.py", line 647, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 307, in _handle_exception

raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])

File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 87, in reraise

raise value

File "/usr/lib/python3/dist-packages/odoo/http.py", line 689, in dispatch

result = self._call_function(**self.params)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 339, in _call_function

return checked_call(self.db, *args, **kwargs)

File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 97, in wrapper

return f(dbname, *args, **kwargs)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 332, in checked_call

result = self.endpoint(*a, **kw)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 933, in __call__

return self.method(*args, **kw)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 512, in response_wrap

response = f(*args, **kw)

File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 930, in call_kw

return self._call_kw(model, method, args, kwargs)

File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 922, in _call_kw

return call_kw(request.env[model], method, args, kwargs)

File "/usr/lib/python3/dist-packages/odoo/api.py", line 689, in call_kw

return call_kw_multi(method, model, args, kwargs)

File "/usr/lib/python3/dist-packages/odoo/api.py", line 680, in call_kw_multi

result = method(recs, *args, **kwargs)

File "/usr/lib/python3/dist-packages/odoo/models.py", line 2535, in read

values[name] = field.convert_to_read(record[name], record, use_name_get)

File "/usr/lib/python3/dist-packages/odoo/models.py", line 4675, in __getitem__

return self._fields[key].__get__(self, type(self))

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 940, in __get__

self.determine_value(record)

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1051, in determine_value

self.compute_value(recs)

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1007, in compute_value

self._compute_value(records)

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 998, in _compute_value

getattr(records, self.compute)()

File "/usr/lib/python3/dist-packages/odoo/addons/sale/models/product_template.py", line 27, in _sales_count

product.sales_count = sum([p.sales_count for p in product.product_variant_ids])

File "/usr/lib/python3/dist-packages/odoo/addons/sale/models/product_template.py", line 27, in <listcomp>

product.sales_count = sum([p.sales_count for p in product.product_variant_ids])

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 940, in __get__

self.determine_value(record)

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1051, in determine_value

self.compute_value(recs)

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1007, in compute_value

self._compute_value(records)

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 998, in _compute_value

getattr(records, self.compute)()

File "/usr/lib/python3/dist-packages/odoo/addons/sale/models/product_product.py", line 19, in _sales_count

for group in self.env['sale.report'].read_group(domain, ['product_id', 'product_uom_qty'], ['product_id']):

File "/usr/lib/python3/dist-packages/odoo/models.py", line 1843, in read_group

result = self._read_group_raw(domain, fields, groupby, offset=offset, limit=limit, orderby=orderby, lazy=lazy)

File "/usr/lib/python3/dist-packages/odoo/models.py", line 1933, in _read_group_raw

self._cr.execute(query, where_clause_params)

File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 155, in wrapper

return f(self, *args, **kwargs)

File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 232, in execute

res = self._obj.execute(query, params)

psycopg2.ProgrammingError: relation "sale_report" does not exist

LINE 3: FROM "sale_report" LEFT JOIN "product_product" a...

Ermin Trevisan

It works in standard Odoo.

Bhavin Patel

The error message you are receiving suggests that there is an issue with the "sale_report" relation, which is used by the "sales_count" field in the "product.product" model. Specifically, the error indicates that the "sale_report" relation does not exist.

This could be caused by a few different things, such as a missing or incorrect module installation, a database inconsistency, or an issue with the codebase itself. Here are a few steps you can take to try and resolve the issue:

Check your module installations: If you recently installed a new module or updated an existing one, it's possible that there was an error during the installation process that caused the "sale_report" relation to not be created properly. Check the module's installation log and verify that it installed without errors. You may also want to try reinstalling the module to see if that resolves the issue.
Verify your database consistency: It's possible that there is a problem with your database that is preventing the "sale_report" relation from being created properly. You can use Odoo's built-in database management tools to check for and repair any inconsistencies. To do this, navigate to the "Settings" menu in Odoo, click "Technical" in the top-right corner, then select "Database Structure" > "Database Integrity". This will run a check on your database and display any inconsistencies that are found. If any inconsistencies are found, you can use the "Repair" button to fix them.
Check the codebase: If neither of the above steps resolves the issue, it's possible that there is a problem with the codebase itself. Check the source code for the "product.product" model and verify that the "sales_count" field is defined correctly and that it references the "sale_report" relation properly. If you're not comfortable with modifying the codebase yourself, you may want to reach out to the Odoo community or a developer for assistance.

Hopefully one of these steps will help you resolve the issue.

¿Le interesa esta conversación? ¡Participe en ella!

Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.

Registrarse

Publicaciones relacionadas	Respuestas	Vistas
Display field only for one company on list view Resuelto sale.order	1 may 25	1990
Sale order Balance sale.order	2 nov 24	2977
Mark a sales order as fully invoiced despite Order amount and invoiced amount do not match () Resuelto sale.order	4 feb 24	13765
sale / delivery Resuelto sale.order	1 ene 24	2405
signature and stamp / sale order sale.order	0 may 23	2620

Se marcó esta pregunta

¿Le interesa esta conversación? ¡Participe en ella!