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

CRM
e-Commerce
Accounting
Inventory
PoS
Project
MRP

All apps

All Posts People Badges

Tags (View all)

odoo accounting v14 pos v15

About this forum

Help

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

sale.order

1 Reply

3182 Views

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.

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

Create an account today to enjoy exclusive features and engage with our awesome community!

Related Posts	Replies	Views
Display field only for one company on list view Solved sale.order	1 May 25	1986
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 () Solved sale.order	4 Feb 24	13763
sale / delivery Solved sale.order	1 Jan 24	2405
signature and stamp / sale order sale.order	0 May 23	2619

This question has been flagged

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