This content has been marked as final. Show 5 replies
Might be easier if you create a when-validate-record personalization on the lines
The personalization displays error message if the item is not valid for the buyer and then stops him/her from saving the line.
Thanks alot for your advice. However, I would prefer if the item does not show in the LOV rathen than having the user enter the entire line...only to be told that they cannot buy the item at the end of it all....
Security rule setup is the only way you can restrict the items to appear in the Item LOV in the purchase order/requisition forms.
Brief setup overview
1. Create a valueset as "Non-Hierarchical Security" and validation type "Independent".
2. Assign the valueset to the respective segment of the "System Items" Key flexfield.
3. Setup security rule for the created valuset at - Setup -> Flexfields -> Key -> Security -> Define in the Inventory superuser or similar responsibility.
4. Add the allowed items in the security rule.
5. Assign security rule to the responsibility.
Now buyer will be able to see only the items listed in the security rule using the responsibility assigned to the security rule.
Thanks. I explored the possiblity of using security rules. However, the items that users can buy (for example chemicals) are not in a range. We currently have thousands of items, and adding them manually will be alot of work...not to forget maintenance of the security rule will be extremely difficult when new items are added?
We have categories and category sets setup for the items that users should and should not buy....Can I use this to determine which items are shown in the LOV? I am aware that E-Biz has a feature whereby you can assign a buyer to a category...but the functionality does not restrict the buyer but rather defaults the category when the buyer is auto-creating POs.
You can setup security rules on categories as well.
Regarding maintenance of security rules, you can develop a custom program which will be scheduled to see the new items created and add them progrmatically to the security rule.
I have done it in one of the project.