Auto-number "Child Accounts" in Context of "Parent Account"

Whats the easiest way to Auto-Number accounts as follows ?

If Account is Parent ( Parent Account is null) then Account Number = Standard Next Increment. example : 10001

If Account is Child ( Parent Account is populated) then Account Number = Parent Account Num + New Child Number Increment.

ABC Oil = 10001 (Parent)

ABC Oil NY = 10001-1 (First Child)

ABC Oil CA = 10001-2 (Second Child)

XYZ Corp = 10002

XYZ Corp TX = 10002-1

XYZ Corp FL = 10002-2

3 answers

venus hindocha (Nasdaq)
Mar 18, 2015, 6:22 PM
Thanks for your response, but that will keep incrementing the auto-number across-parents. I need the auto-number to increment only within the context of a parent. so per my example in the post, the ABC Oil CA got the number as 2 and then XYZ Corp TX, will get number 3 per your solution, but i need that to start at 1, since its the First Child account for this different Parent.

Add a comment

0/9000

Salesforce Developer