SI.EXPANDACCOUNTSINGROUP return child account groupings by account group

Posted about 1 month ago by Tom Roberts

T
Tom Roberts

0 Votes

We have a number of nested account groups it would be useful to have SI.EXPANDACCOUNTSINGROUP or a similar function return an array which shows the nested names and account numbers. 

Example:  

Lets say we have an account group Revenue,  it is comprised of two account groups Contributions and Registration.  
Revenue:  Contributions , Registration 
     Contributions: 40000,40010,40020,40030
     Registration: 40060,4007

Current function of SI.EXPANDACCOUNTSINGROUP(connection,"Revenue")  would return all of the account numbers:

40000
40010
40020
40030
40060
40070


What would be helpful to get is an array like the below:

RevenueContributionsRegistration
400004000040060
400104001040070
4002040020
4003040030
40060

40070


This could be done with SI.EXPANDACCOUNTSINGROUP  with a parameter flag like [expand child groups]  or as a separate function




=== Please type above and preserve the below information ===

Name: Roberts, Tom

Excel version: PC 16.0.17328.20282

Connection: MADD

0 Votes


1 Comments

Damien Zwillinger

Damien Zwillinger posted 24 days ago Admin

Thanks Tom!


I have moved your Topic to the Sage Intacct forum.


That is an interesting idea. We have had similar requests for expanding one Account group to its descendants (groups and/or accounts), but this idea is new. We will consider it!

1 Votes

Login or Sign up to post a comment