I have the following case:
I have an Employee/HR dashboard containing the entities subsidiary (A & B) and sales office (1 & 2).
After loading data from the server I have the following picture:
Employees of subsidiary A & B are all assigned to Sales Office 1. The problem is that this is not 100% correct, which relates back to our backend database. I know it should be fixed there, but this is not easy, that's why I am looking for a way to adjust entitiy assignment via procedure.
What I would like to do is to use the following criteria:
- If employees are in subsidiary B the entity should be sales office 2. If employees are in subsidiary 1 they should be assigned to sales office 1.
Hope my example is clear. General questions is if it is possible to adjust entities automatically by a procedure using predefined selectors. If so how can I do that?