Skip to main content

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.

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 

@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.

@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?

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.

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

Hello!

 

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

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. 

Reply


Terms & ConditionsCookie settings