I have a sales team divided in workgroups, each group is responsible selling a different group of items, each group will process the sales orders for their products, and some groups might interact with same customers.
I’m looking for a solution how I can restrict a workgroup to access sales orders from another workgroup, I’m using the row level security on the inventory items so they can only work with their own products, however they can still access existing documents in the system from another workgroup.
Would anyone have a solution? So far the row level security can only restrict on vendors, customers, items, and GL but not on documents.