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

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

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

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

2 Replies

4084 Views

acl pricelist yearend AccessError odoo8

Clemens John

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

Pawan

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

Clemens John

Author

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

This question has been flagged