We have a set of stock items, and those items are allowed to sell to only a customer. Is there a way we can restrict so we don’t sell to other customers?
Is there a way to restrict sales ability to sell stock item to only to a certain customer?
Yes, you can set up Row Level Security → Restriction Groups to link Stock Items, Users, and Customers to create a situation where certain items can only be sold to certain customers. Here is a link where someone successfully linked, using the Salesperson with items and customers. There is a lot of detail in this link, including info from Dana Moffat, Acumatica Employee
Laura
I tried the suggested solution, it doesn't work. Following is what i did;
- Created a restriction group and added Inventory Item first and saved.
- For the same group I added Customer and User.
- I could go and create sales order for different customer for the restricted inventory item.
Not sure what I am doing wrong. Any help is appreciated.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/af634af9-9524-4936-acca-961ed45dbaba.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/e57c117e-dc80-4896-97d1-4ec35769312d.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/ded15280-96dd-4242-ad85-6bfa9ff4a7b2.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/8df617e2-9dfb-446c-bf2d-167986d6ab99.png)
Update: my previous post was incorrect. Here is a better answer:
There is no way (yet) to restrict Customers and Inventory Items.
10 months ago, at the time this first link below was posted, Dana Moffat of Acumatica was conducting interviews with clients and collecting ideas. Details can be found here:
We can vote for the idea to allow restriction of items and customers here (link):
Restrict product availability by customer
One possible work-around is provided by Doug Johnson of Acumatica in the second link above.
Laura
You can restrict it to a specific user, the sales rep for that customer for example.
Another alternative, especially since you mentioned UOM, would be to use prices. Set the default or base price to a very high number, this can be done for a specific UOM and warehouse as well when using base prices. Then put the actual price in as a customer price.
Other work arounds would be a Business event to alert you when it does sell the wrong customer or even edit the sales order, put it on hold or add a note.
Setting up related items for this to create another reminder that another item should be used may help.
I've also seen rarely sold products set to No Sales status and the item would be changed for that order. This is only practical for very rare items though.
Unfortunately every non-customization solution I can think of requires a person to not do it wrong, Doug's solution greatly reduces how many people it impacts.
We also need to be able to restrict the service items based on customers who are prevailing wage customers. We have setup a customer price class called PREVAILING that we have assigned to Prevailing Wage customers and then we have setup some service items with PREVAILING price class ID. We need to be able to restrict the detail lines that are service items to only show those items that have PREVAILING price class. On other detail lines that are Stock or NonStock, the restriction needs to not be in effect.
We are trying to write a customization but have not had any luck getting it to dynamically restrict the item lookup based on LineType and customer price class ID.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.