Skip to Content
This question has been flagged
Quantity on Hand
3 Replies
2485 Views
Avatar
Markus Schmid

By default the inventory user has a smart button called Quantity on Hand.....

The path to it obviously is Inventory -> Products Menu -> click on one of the Products in the kanban....

The struggle that I have is that the purchase user should also have this button / information without being able to edit the quantity would be a bonus...

Purchase -> Products Menu -> click on one of the Products in the kanban....  (now the onhand quantiy button is missing)

The additional limiting factor is that we are using odoo online....

 ....can this be done through studio?  And if so how?   

Avatar
Discard
Avatar
Jaideep
Best Answer

I think there is not any easy way to do this (but I might be wrong). The visibility of field on-hand qty field has been set to Inventory/user and even by removing or changing visibility to Internal users does not provides visibility to Purchase/ user

The work around to achieving this was a provide inventory user access to purchase / user, while taking away all the access rights.

  1. Duplicate Inventory / user group - Setting > User & Companies > Groups
  2. Rename the original group to maybe 'Inventory Info' and the duplicated group to Inventory / user (it doesn't work the other way around)
  3. In the access rights of Inventory/ Info delete all the access rights, ensure the inherited groups has Internal user

4. For Inventory /User group ensure inherited group has Internal users and well as Inventory / info. Ensure to preserver the access rights as is

5. For Purchase / User group add or update Inventory / info as inherited group. Preserve the access rights as is


This should now provide the required 'on-hand qty' field to be visible to purchase / user group. The on hand qty is also visible on the Kanban view


However, they would also have access to Inventory app and menu's. 

To disable the menu, navigate to Settings > Technical > Menu items - search for inventory and delete visibility for Inventory / Info group.

While this would get you probably what you are looking for (and more), am not sure if I would recommend to implement it. Please test thoroughly (on a test DB probably by duplicating production) all aspects of access including those of the inventory users to ensure compliance and access. 

Hope the experts on this forum have a better solution.

Avatar
Discard
Markus Schmid
Author

Jaideep, thanks for the reply... I tried a bit of different take on your suggestion, --maybe you have a solution... :-).....
... in the Groups Menu I made a copy of the Intentory/user group. I called the copy of the group Intentory/purchasing.... Now when I go into the settings -> Manage users -> "purchasing user" -> access rights and look into the Inventory Section / inventory drop down I still only get the "user" or "administrator".... ....the strange thing, -when I did the same step with the "billing" in accounting calling it "test" then the "test" does appear in the selection box.... ....any ideas?

Jaideep

Hi, not sure if the copy was saved or maybe you would have to refresh after saving the copy for it to reflect in user settings. It is possible sometimes if you have 2 windows open.

Also, if you are trying to follow the suggested solution, ensure to rename the original group to Inventory/purchase and not the copy (point2)

Avatar
Markus Schmid
Author Best Answer

If you give a user only access to purchasing, how can the user see quantity on hands at the products (item master level)

purchasing user does have product / item Master level access by default.   Giving the purchassing person inventory access is not doable because of GAAP rules

Avatar
Discard
Markus Schmid
Author

Ok, I succesfully killed the inventory option under user settings. The only luck is that I am playing in a test database... And when I mean gone, I mean the complete label (Inventory) and associated drop down box...
Deleting the new inventory group also did not work... very strange.... Odoo 17.4

Markus Schmid
Author

AND WOW.... ...going into the Studio Tool to look at invisible fields does not reveal the Inventory label Inventory dropdown combo.. WOW :-(

Avatar
Hussein Soliman
Best Answer

You can remove Access create from puchase user in modules "  stock.quant"

in this case the purchase user can't edit stock 

Avatar
Discard
Related Posts Replies Views Activity
Importing Product Quantity
Quantity on Hand
Avatar
Avatar
Avatar
Avatar
4
Jun 24
18583
Can't Update Quantity on Hand Odoo 13 EE Solved
Quantity on Hand
Avatar
Avatar
Avatar
3
Jan 21
6036
On-hand qty update while creating MO
Manufacturing Order Quantity on Hand
Avatar
Avatar
Avatar
2
May 23
2984
[Odoo 13 CE] Inventory Update with product qty on hand = 0
Quantity on Hand InventoryAdjustment
Avatar
0
Aug 22
1837
Access right for "Inventory/User" to update Quantity On Hand. Odoo 14 Enterprise Solved
inventory Quantity on Hand
Avatar
Avatar
Avatar
2
Mar 22
6595