Skip to main content
Solved

Restrict Items by Warehouse in single Company Zero branches setup

  • November 1, 2022
  • 8 replies
  • 423 views

Forum|alt.badge.img+1

Hi All,

 

We are currently trying to figure out a way to restrict items per Warehouse.

The company has a single Company Zero Branches setup, so we wouldn’t be able to restrict items and warehouse on a branch level for example.

 

Is there a way of telling Acumatica in this set-up that specific items can only be used in Warehouse X but not used in Warehouse Y?

Any ideas or experience would help!

 

Unfortunately assigning Item Classes to Warehouse locations wouldn’t work here as the client has multiple item classes that would be allowed in each Warehouse and there is also some Overlap there.

Best answer by marina25

Hello,

The proper restriction to optimize is the following:

  1. Create warehouse access in the Row Level Security
  2. If you do not want the users to access a specific warehouse, then the type is A-Inverse and select the warehouses that should not be accessed. 
  3. Select the users which should not have access to the warehouse.
  4. Repeat steps 1 and 2 for Inventory Item Access if specific items should not be available for users. 

    A-Inverse allows to hide access. 

View original
Did this topic help you find an answer to your question?

8 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • November 1, 2022

Hello,

In Restriction Groups it seems like we can connect items to warehouses.  I’m not sure if User is required in a restriction group... just an idea you may try in your test environment.

 


Hi, 

 

Did you find a way to restrict the item by warehouse? I am also looking to implement it. I tried but the user then cannot see the item all together :)

 

Let me know if you found a way.

 

Thanks, 

Patricia 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • November 2, 2022

@patriciabatisti2

If the user can’t see the item, pay attention to the Restriction Group Type. Group Types A versus B controls whether a user can or cannot see, specifically when the user, warehouse, or item is in more than one group.  Study whether the group needs to be Inverse; examples can be found in the help. 

I think Restriction Group Types can be confusing; I recommend trying each type in a test environment until the desired result for the users is achieved.


Forum|alt.badge.img+1
  • Author
  • Semi-Pro I
  • 184 replies
  • November 2, 2022
laura01 wrote:

@patriciabatisti2

If the user can’t see the item, pay attention to the Restriction Group Type. Group Types A versus B controls whether a user can or cannot see, specifically when the user, warehouse, or item is in more than one group.  Study whether the group needs to be Inverse; examples can be found in the help. 

I think Restriction Group Types can be confusing; I recommend trying each type in a test environment until the desired result for the users is achieved.

I think the Key for both Patricia and me is to not have it User-specific but rather just restrict Items to a specific Warehouse.

 

For some reason I cannot get consistent results and I was wondering if you would be able to provide a Sample Set-up?


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • November 2, 2022

I’m sorry, I don’t have an example built out and I’m short on time. I expect your partner can assist. Or, someone who has an example may come along.


  • Freshman I
  • 14 replies
  • October 5, 2023

Were you able to find a way to do this without a customization?


jionymacabuhay
Varsity I
Forum|alt.badge.img

Hello!

 

Does anybody already did this? 😁 We need to restrict the selection of items in Sales Order for specific warehouse only.


Forum|alt.badge.img+1
  • Jr Varsity I
  • 57 replies
  • Answer
  • June 24, 2024

Hello,

The proper restriction to optimize is the following:

  1. Create warehouse access in the Row Level Security
  2. If you do not want the users to access a specific warehouse, then the type is A-Inverse and select the warehouses that should not be accessed. 
  3. Select the users which should not have access to the warehouse.
  4. Repeat steps 1 and 2 for Inventory Item Access if specific items should not be available for users. 

    A-Inverse allows to hide access. 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings