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:
Revenue
Contributions
Registration
40000
40000
40060
40010
40010
40070
40020
40020
40030
40030
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
1 Votes
2 Comments
Sorted by
A
Allisonposted
about 1 month ago
This would be really helpful!
0 Votes
Damien Zwillingerposted
7 months 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
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:
What would be helpful to get is an array like the below:
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
1 Votes
2 Comments
Allison posted about 1 month ago
This would be really helpful!
0 Votes
Damien Zwillinger posted 7 months 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!
2 Votes
Login or Sign up to post a comment