Workaround for Parent Child Relationship for Boolean Lookup
Hello, I am trying to do a workaround where I am not able to directly map a Parent and Child relationship but the users would want to be able to alert owners of a subsidiary account living in a different territory that they want that subsidiary to follow their HQ account.
A specific example would be: Account 1 HQ has 4 Subsidiary Accounts but the 4 Subsidiary Accounts live in different territories. Due to RBAC constraints and the team not wanting the hierarchy to Territory to Parent to Child but just Territory to All Accounts, I need a workaround so that the DM of the HQ account can check a box off saying that they want all the Subsidiaries to follow HQ to whatever new territory they are going to. I have the box check-off done, but it is the fact that I have two different lists (HQ Accounts and All Accounts) that is making things a bit difficult for me.
I made a system module mapping table separately where I am able to map the list with All Accounts with their HQ Account. This is the equation I am using for my Test column:
IF Global Ultimate Parent Account ID = 'SYS031: Parent Child Mapping'.Parent Account Code THEN Parent Account Transfer Request?[LOOKUP: 'SYS031: Parent Child Mapping'.'Account Name (List Format)'] ELSE FALSE
The problem with is that, in the example below, the Parent Account Transfer Request? fill out the child accounts boolean in the Test column but it is just checking things off. I have tried to make a separate module that has the Parent Account List as I have successfully been able to use that to get the child booleans checked off, but due to RBAC constraints and that Parent Account List not having the correct hiearchy, it becomes a hassle. Any thoughts from anyone?