Skip to Content
Menu
This question has been flagged

Hello Odoo Community:

   I am adding a custom field: many2many relation between the purchase.order model and project\.task\.id; however,\ I\ got\ the\ following\ error\ message\ when\ I\ try\ to\ select\ a\ purchase\ order\ from\ the\ database:

Error:
Odoo\ Server\ Error

Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\addons\base\models\ir_http\.py",\ line\ 237,\ in\ _dispatch
\ \ \ \ result\ =\ request\.dispatch\(\)
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\http\.py",\ line\ 685,\ in\ dispatch
\ \ \ \ result\ =\ self\._call_function\(\*\*self\.params\)
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\http\.py",\ line\ 361,\ in\ _call_function
\ \ \ \ return\ checked_call\(self\.db,\ \*args,\ \*\*kwargs\)
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\service\model\.py",\ line\ 94,\ in\ wrapper
\ \ \ \ return\ f\(dbname,\ \*args,\ \*\*kwargs\)
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\http\.py",\ line\ 349,\ in\ checked_call
\ \ \ \ result\ =\ self\.endpoint\(\*a,\ \*\*kw\)
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\http\.py",\ line\ 914,\ in\ __call__
\ \ \ \ return\ self\.method\(\*args,\ \*\*kw\)
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\http\.py",\ line\ 533,\ in\ response_wrap
\ \ \ \ response\ =\ f\(\*args,\ \*\*kw\)
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\addons\web\controllers\main\.py",\ line\ 1352,\ in\ search_read
\ \ \ \ return\ self\.do_search_read\(model,\ fields,\ offset,\ limit,\ domain,\ sort\)
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\addons\web\controllers\main\.py",\ line\ 1371,\ in\ do_search_read
\ \ \ \ return\ Model\.web_search_read\(domain,\ fields,\ offset=offset,\ limit=limit,\ order=sort\)
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\addons\web\models\models\.py",\ line\ 62,\ in\ web_search_read
\ \ \ \ records\ =\ self\.search_read\(domain,\ fields,\ offset=offset,\ limit=limit,\ order=order\)
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\models\.py",\ line\ 4842,\ in\ search_read
\ \ \ \ records\ =\ self\.search\(domain\ or\ \[\],\ offset=offset,\ limit=limit,\ order=order\)
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\models\.py",\ line\ 1708,\ in\ search
\ \ \ \ res\ =\ self\._search\(args,\ offset=offset,\ limit=limit,\ order=order,\ count=count\)
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\models\.py",\ line\ 4514,\ in\ _search
\ \ \ \ query\ =\ self\._where_calc\(args\)
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\models\.py",\ line\ 4270,\ in\ _where_calc
\ \ \ \ return\ expression\.expression\(domain,\ self\)\.query
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\osv\expression\.py",\ line\ 442,\ in\ __init__
\ \ \ \ self\.parse\(\)
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\osv\expression\.py",\ line\ 654,\ in\ parse
\ \ \ \ raise\ ValueError\("Invalid\ field\ %s\.%s\ in\ leaf\ %s"\ %\ \(model\._name,\ path\[0\],\ str\(leaf\)\)\)
Exception

The\ above\ exception\ was\ the\ direct\ cause\ of\ the\ following\ exception:

Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\http\.py",\ line\ 641,\ in\ _handle_exception
\ \ \ \ return\ super\(JsonRequest,\ self\)\._handle_exception\(exception\)
\ \ File\ "C:\Program\ Files\Odoo\ 14\.0\.20220420\server\odoo\http.py", line 317, in _handle_exception
raise exception.with_traceback(None) from new_cause
ValueError: Invalid field purchase.order.client_order_ref in leaf ('client_order_ref', 'ilike', '2023-03-03')

I did the exact thing for the sale order module, and everything works normally, plz let me know how I can fix the issue. Thank you so much. 

Avatar
Discard

Hello,
In Odoo 14 purchase order, there is no field called " client_order_ref " which is mentioned in your error. It's only available on sale. So please ensure that the field client_order_ref is not used in your code.
Regards

Author

Thank you!

Author

How can I fix it?

Related Posts Replies Views Activity
1
Feb 24
2033
0
Jul 24
3106
0
Jul 22
60
1
Jul 22
2984
2
Dec 23
33495