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

CRM
e-Commerce
Účetnictví
Sklad
PoS
Projekty
MRP

All apps

All Posts Lidé Odznaky

Štítky (View all)

odoo accounting v14 pos v15

O tomto fóru

Pomoc

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

sale.order

1 Odpovědět

3193 Zobrazení

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!

Přihlásit se

Related Posts	Odpovědi	Zobrazení
Display field only for one company on list view Vyřešeno sale.order	1 kvě 25	1993
Sale order Balance sale.order	2 lis 24	2978
Mark a sales order as fully invoiced despite Order amount and invoiced amount do not match () Vyřešeno sale.order	4 úno 24	13766
sale / delivery Vyřešeno sale.order	1 led 24	2407
signature and stamp / sale order sale.order	0 kvě 23	2621

This question has been flagged

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