Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

No value found for product.pricelist(1,).currency_id

By
Clemens John
on 1/5/16, 5:36 AM 478 views

Hi,

I'm facing an issue on my Odoo 8 installation for some days now that I don't know how to fix. The following error always occurs when I want to create a new order in the sales module and try to a assign a customer to the order.

While searching aroung the net I already found out that the error does not occur when using the admin account because the admin bypasses all ACL checks. Because the error did pop up around new year I also took a look at some settings like fiscal year in the accounting module and found out, that there is no fiscal year created for 2016. Maybe this is related somehow and if so, is there any documentation what to check on a new year?

This is the error I'm facing:


2016-01-04 17:32:53,777 29602 INFO odoo_ffnw werkzeug: 127.0.0.1 - - [04/Jan/2016 17:32:53] "POST /web/dataset/call_kw/res.partner/name_search HTTP/1.0" 200 -

2016-01-04 17:32:55,091 29602 WARNING odoo_ffnw openerp.addons.base.ir.ir_model: Access Denied by ACLs for operation: read, uid: 12, model: product.pricelist

2016-01-04 17:32:55,091 29602 ERROR odoo_ffnw openerp.http: Exception during JSON request handling.

Traceback (most recent call last):

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 530, in _handle_exception

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 567, in dispatch

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 303, in _call_function

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

File "/usr/lib/python2.7/dist-packages/openerp/service/model.py", line 113, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 300, in checked_call

return self.endpoint(*a, **kw)

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 796, in __call__

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 396, in response_wrap

response = f(*args, **kw)

File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 936, in call_kw

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

File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 928, in _call_kw

return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 363, in old_api

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

File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 5846, in onchange

record._onchange_eval(name, field_onchange[name], result)

File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 5762, in _onchange_eval

method_res = getattr(self._model, method)(*args, context=self._context)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/addons/sale/sale.py", line 299, in onchange_pricelist_id

'currency_id': self.pool.get('product.pricelist').browse(cr, uid, pricelist_id, context=context).currency_id.id

File "/usr/lib/python2.7/dist-packages/openerp/fields.py", line 823, in __get__

return record._cache[self]

File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 5913, in __getitem__

return value.get() if isinstance(value, SpecialValue) else value

File "/usr/lib/python2.7/dist-packages/openerp/fields.py", line 55, in get

raise self.exception

AccessError: ('AccessError', 'No value found for product.pricelist(1,).currency_id')

2016-01-04 17:32:55,093 29602 INFO odoo_ffnw werkzeug: 127.0.0.1 - - [04/Jan/2016 17:32:55] "POST /web/dataset/call_kw/sale.order/onchange HTTP/1.0" 200 -

2016-01-04 17:32:53,777 29602 INFO odoo_ffnw werkzeug: 127.0.0.1 - - [04/Jan/2016 17:32:53] "POST /web/dataset/call_kw/res.partner/name_search HTTP/1.0" 200 -

2016-01-04 17:32:55,091 29602 WARNING odoo_ffnw openerp.addons.base.ir.ir_model: Access Denied by ACLs for operation: read, uid: 12, model: product.pricelist

2016-01-04 17:32:55,091 29602 ERROR odoo_ffnw openerp.http: Exception during JSON request handling.

Traceback (most recent call last):

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 530, in _handle_exception

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 567, in dispatch

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 303, in _call_function

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

File "/usr/lib/python2.7/dist-packages/openerp/service/model.py", line 113, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 300, in checked_call

return self.endpoint(*a, **kw)

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 796, in __call__

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 396, in response_wrap

response = f(*args, **kw)

File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 936, in call_kw

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

File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 928, in _call_kw

return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 363, in old_api

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

File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 5846, in onchange

record._onchange_eval(name, field_onchange[name], result)

File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 5762, in _onchange_eval

method_res = getattr(self._model, method)(*args, context=self._context)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/addons/sale/sale.py", line 299, in onchange_pricelist_id

'currency_id': self.pool.get('product.pricelist').browse(cr, uid, pricelist_id, context=context).currency_id.id

File "/usr/lib/python2.7/dist-packages/openerp/fields.py", line 823, in __get__

return record._cache[self]

File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 5913, in __getitem__

return value.get() if isinstance(value, SpecialValue) else value

File "/usr/lib/python2.7/dist-packages/openerp/fields.py", line 55, in get

raise self.exception

AccessError: ('AccessError', 'No value found for product.pricelist(1,).currency_id')

2016-01-04 17:32:55,093 29602 INFO odoo_ffnw werkzeug: 127.0.0.1 - - [04/Jan/2016 17:32:55] "POST /web/dataset/call_kw/sale.order/onchange HTTP/1.0" 200 -

2016-01-04 17:32:53,777 29602 INFO odoo_ffnw werkzeug: 127.0.0.1 - - [04/Jan/2016 17:32:53] "POST /web/dataset/call_kw/res.partner/name_search HTTP/1.0" 200 -

2016-01-04 17:32:55,091 29602 WARNING odoo_ffnw openerp.addons.base.ir.ir_model: Access Denied by ACLs for operation: read, uid: 12, model: product.pricelist

2016-01-04 17:32:55,091 29602 ERROR odoo_ffnw openerp.http: Exception during JSON request handling.

Traceback (most recent call last):

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 530, in _handle_exception

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 567, in dispatch

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 303, in _call_function

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

File "/usr/lib/python2.7/dist-packages/openerp/service/model.py", line 113, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 300, in checked_call

return self.endpoint(*a, **kw)

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 796, in __call__

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 396, in response_wrap

response = f(*args, **kw)

File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 936, in call_kw

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

File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 928, in _call_kw

return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 363, in old_api

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

File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 5846, in onchange

record._onchange_eval(name, field_onchange[name], result)

File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 5762, in _onchange_eval

method_res = getattr(self._model, method)(*args, context=self._context)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/addons/sale/sale.py", line 299, in onchange_pricelist_id

'currency_id': self.pool.get('product.pricelist').browse(cr, uid, pricelist_id, context=context).currency_id.id

File "/usr/lib/python2.7/dist-packages/openerp/fields.py", line 823, in __get__

return record._cache[self]

File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 5913, in __getitem__

return value.get() if isinstance(value, SpecialValue) else value

File "/usr/lib/python2.7/dist-packages/openerp/fields.py", line 55, in get

raise self.exception

AccessError: ('AccessError', 'No value found for product.pricelist(1,).currency_id')

2016-01-04 17:32:55,093 29602 INFO odoo_ffnw werkzeug: 127.0.0.1 - - [04/Jan/2016 17:32:55] "POST /web/dataset/call_kw/sale.order/onchange HTTP/1.0" 200 -


Any help would be appreciated

0

Pawan

--Pawan--
1267
| 4 3 5
Hyderabad, India
--Pawan--


Pawan
On 1/7/16, 2:12 AM

Clemens,

This is an access error while accessing the currency id(particularly assigned to priclist with id 1),

One of the two possible reasons could be that, the company of that currency id is different from the current logged in users company

AND

other could be, user is not having read access to res.currency object( not provided access right or violating some access rule).

Regards    


 

0
Clemens John
On 1/6/16, 3:25 AM

I could magically solve the problem by updating the base module. I needed to run the update process twice because there was an error when running it for the first time.

Reference:

https://www.odoo.com/de_DE/forum/hilfe-1/question/how-to-handle-currencies-missing-issue-15204

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 1/5/16, 5:36 AM
Seen: 478 times
Last updated: 1/7/16, 2:12 AM