SI.EXPANDACCOUNTSINGROUP return child account groupings by account group

Use case as presented would let us change account groups within Sage Intacct and have those changes be reflected in Velixo reports under the correct sub account groups automatically.  We also have a large number of nested account groups and being able to quickly identify what roll up levels exists would be very helpful as it would let us build reports knowing each roll up level. without having to constantly cross check account groups within Sage Intacct to see what rolls into what. This adds additional dynamic options to our report creation capabilities.  

As for indenting, it would hurt more than it would help in my specific case. My current solution for this is a massive list of each account group expanded one by one and a lot of index matching.  For some reporting needs we may have one account appear in multiple different account groups.  Indenting would make this problematic as it would likely result in duplicative info.   

Hi Tom. Coming back to this one. How would you use such array in a report? How would you reference these cells?

Would it make more sense to expand those account groups and accounts into a single column instead but indent them to give clues about their hierachical level? (and we could look at parsing the indentations and truncating the spaces when these values are referenced in other functions such as Turnover)

The same requirement exists for hierarchical dimensions.

This would be really helpful!

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!