Yes, you can restrict users department-wise in Business Central using Security Filters within Custom Permission Sets.
Approach:
- Create Custom Permission Sets: For each department (Sales, Purchase, Finance).
- Assign Permissions: Grant access to the relevant tables/pages needed by that department (e.g., Sales users get Sales Order tables).
- Apply Security Filters: On tables where you want to restrict record-level access (e.g., Sales Header, Purchase Header), add a Security Filter.
- Example: For "Sales Department User" permission set, add a filter on the "Department Code" field (if you have one) on the Sales Header table, allowing only their department's code.
In short: Use Custom Permission Sets with Security Filters on relevant tables to restrict record-level access based on department.
Mark this answer as verified if it helps you.