The EXPANDACCOUNTGROUPRANGE function is useless for us. There is no way to filter by Asset, Liability, Income and Expense unless we change our account group codes. Could that be updated in the future to allow us to filter by Type?
Right now we have to export the list and lookup the values in that list.
0 Votes
2 Comments
Sorted by
Gabriel Michaudposted
about 1 hour ago
Sneak peek at the next version of Velixo:
As an example, =EXPANDACCOUNTGROUPRANGE("Acumatica",,,"E") will give you expense account groups only.
0 Votes
Gabriel Michaudposted
about 4 hours ago
Hi Dean,
Fair point, and I've already raise a suggestion internally to modified the function to add an argument that would allow you to filter by type.
In the meantime, here's a function that will give you a list of account groups filtered by type:
0 Votes
The EXPANDACCOUNTGROUPRANGE function is useless for us. There is no way to filter by Asset, Liability, Income and Expense unless we change our account group codes. Could that be updated in the future to allow us to filter by Type?
Right now we have to export the list and lookup the values in that list.
0 Votes
2 Comments
Gabriel Michaud posted about 1 hour ago
Sneak peek at the next version of Velixo:
As an example, =EXPANDACCOUNTGROUPRANGE("Acumatica",,,"E") will give you expense account groups only.
0 Votes
Gabriel Michaud posted about 4 hours ago
Hi Dean,
Fair point, and I've already raise a suggestion internally to modified the function to add an argument that would allow you to filter by type.
In the meantime, here's a function that will give you a list of account groups filtered by type:
=LET(AccountGroups,GI("Acumatica","VelixoReportsPro-AccountGroups",,"Type,AccountGroupCD",FALSE),INDEX(FILTER(AccountGroups,INDEX(AccountGroups,,1)="Expense",""),,2))
Just replace "Acumatica" by your actual connection name, and "Expense" by the type you are interested in.
Internal reference for the enhancement: RD-13334
0 Votes
Login or Sign up to post a comment