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

客戶關係
e-Commerce
會計
庫存
PoS
專案管理
MRP

All apps

所有帖文人獎章

標籤（查看所有）

odoo accounting v14 pos v15

關於此討論區

支援

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

sale.order

1 回覆

3211 瀏覽次數

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.

喜歡這則討論？不要只閱讀，加入發表意見吧！

今天就建立帳戶，享受獨家功能，與我們精彩的社群互動！

註冊

相關帖文	回覆	瀏覽次數
Display field only for one company on list view 已解決 sale.order	1 5月 25	1999
Sale order Balance sale.order	2 11月 24	2981
Mark a sales order as fully invoiced despite Order amount and invoiced amount do not match () 已解決 sale.order	4 2月 24	13776
sale / delivery 已解決 sale.order	1 1月 24	2407
signature and stamp / sale order sale.order	0 5月 23	2624

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！