Problem Statement/Use Case
- The banks' Financial Accounts can have multiple Joint owners
- There is no concept of a 'Primary'
- Need to model Financial Accounts and the Roles to reflect this (and have multiple Joint Owners)
- Q: How do we do this considering the below...?
Current Best Practise & Salesforce Financial Accounts out-the-box:
- When a Sole Account
- Set the Account Type as 'Individual'
- Enter in a Primary Owner (mandatory)
- When a Joint Account
- Set the Account Type as 'Joint'
- Enter in a Joint Owner
- This auto-creates the Financial Account Roles of 'Primary' (and 'Joint' when a Joint Owner is added)
- The 'Primary' and 'Joint' Financial Account Roles are not selectable because it's managed by the FSC package via those lookup fields on the Financial Account
Workaround/Current Thinking
- We can't get around the need to enter a 'Primary Owner'
- Therefore, will use the first Joint Owner entered on the banking system as the 'Primary'
- For all Joint Owners, we have to ignore the use of Account Type (and the functionality of FSC rollups that go with this) and ignore the Joint Owner lookup entry.
- Instead model all Joint Owners (multiple) via the Financial Account Role records with a custom 'Joint' role (instead of the FSC one that's deactivated unless you add a Joint Owner on the Account).
Any thoughts/recommendations welcome. I feel this is a major gap in the world where there are multiple Joint Owners (or not visible in any documentation)
To reiterate your assessment -> This is a major gap. SF would need to alter its data model for Ownership of a Financial Account to resolve this natively.
Potential 'additional' Workarounds outside of your list:
- Additional metadata could provide details about said "Primary" and "Joint" to indicate the actual status (everyone is a joint and primary is moot) on the UI
Rollups:
- Utilize Data Processing Engine to perform rollups with Role Data as an attribute of aggregation and joins. i.e., utilize Role as an additional factor for determining totals.
This works outside of FSC Triggers and would need to be triggered by a flow (usually after nightly batch jobs are completed for ingesting data into the system)
- Disable the Batch trigger for RollupByLookup configurations and set it to real-time, then have the DPE run calculations as needed.
