This question has been flagged
4 Replies
5449 Views

In my company, there are 30 warehouses. all users can access all warehouses. But  I want to assign user to each respective warehouse. I do not want to show others.

Avatar
Discard

For those who faced the same requirement: this app - https://apps.odoo.com/apps/modules/15.0/stock_limitation/ - lets assign users for stock locations

Best Answer

I did all the steps below, but the user gets the following error when creating a pre-invoice or purchase order. How can I solve this problem?

psycopg2.DataError: invalid input syntax for integer: "w.id for w in user.x_warehouse_ids"
LINE 1: ...mpany_id" in (1)) AND ("stock_warehouse"."id" in ('w.id for ...


Avatar
Discard
Best Answer

it works perfect , thanks for support

Avatar
Discard
Best Answer

This has to be done using record rules and access groups. Refer the Odoo documentation in the below link

https://www.odoo.com/documentation/15.0/developer/howtos/rdtraining/B_acl_irrules.html


Avatar
Discard