Hello, when I am using the =accountsandsubaccountswithhistory function, I have encountered an error that I was previously not getting, and I am not sure what is causing this.
When I use "*", or leave blank for BranchorRange, I get an error:
Connection 'Error! Index was out of range. Must be non-negative and less than the size of the collection.
This happened after closing and reopening my workbook, and it was working fine before. Now the only way I can get this function to work appropriately is to designate a specific branch, which is not what I want to do. Has anyone encountered this or know what may be causing it?
Function with error:
Function when designating a specific Branch:
Any ideas would be much appreciated! Thanks!
0 Votes
1 Comments
Gabriel Michaudposted
10 months ago
Admin
Hi Max,
It might be something specific to your Acumatica instance. I will reach out privately.
0 Votes
Hello, when I am using the =accountsandsubaccountswithhistory function, I have encountered an error that I was previously not getting, and I am not sure what is causing this.
When I use "*", or leave blank for BranchorRange, I get an error:
This happened after closing and reopening my workbook, and it was working fine before. Now the only way I can get this function to work appropriately is to designate a specific branch, which is not what I want to do. Has anyone encountered this or know what may be causing it?
Function with error:
Function when designating a specific Branch:
Any ideas would be much appreciated! Thanks!
0 Votes
1 Comments
Gabriel Michaud posted 10 months ago Admin
Hi Max,
It might be something specific to your Acumatica instance. I will reach out privately.
Regards,
Gabriel
0 Votes
Login or Sign up to post a comment