Question

Account Hierarchy with custom lookup field?

  • 1 November 2016
  • 10 replies
  • 371 views

Userlevel 7
Badge +3
Has anyone successfully set up Account Hierarchy using a custom lookup field?



Going into Administration/Account Hierarchy, I have the option of only selecting Parent Account ID from the lookup relationship field picklist.  The fact that it is a picklist tells me I should have the ability to have more than one option.  We are in the process of determining now how to enable AH, but we aren't able to use Parent Account ID (due to reasons) but want to potentially leverage a custom object.  Anyone know how to enable a custom object to appear in this picklist?




10 replies

Badge +1
Hello Jeff,



Please create a custom lookup field on Accounts object. It should be a self lookup field i.e., both parent and child objects should be Accounts itself.







The same custom lookup field will be displayed in Account Hierarchy configuration page, select the field you have created instead of the default Parent Account ID field provided by Salesforce.







This process will enable your use case.
Userlevel 7
Badge +3
Thanks bangar!
Can another object be used? Say a lookup to a custom object?
Badge +1
No, you can't use any of the object other than Accounts to capture the hierarchy flow of an Organisation/Customer. 



You can use a lookup to only Accounts object.
Got it. Thanks!
Userlevel 6
Badge +1
Amber - We could potentially use the Relationships feature to help out with your custom object scenario. Happy to connect and chat further.
Thanks @Manu. We haven't settled on a plan yet, but will definitely engage when we're closer. Thanks!
Badge
Currently the AH is showing us Accounts that have not been added to Gainsight, such as Prospects. Is there a way to filter the AH section to only show specific customers? i.e. Active customers (Status = Active)?
Userlevel 6
Badge +1
We are adding some AH section level filtering and sorting options in the next release. Would you also want to exclude such Accounts from roll-up calculations?
Badge
Did the filtering and sorting options get added?

Reply