By using this website, you agree to our Terms of Use (click here)
We have a client who has over 200 locations (each one specified as a different subaccount). They set up unit sets to run their consolidated P&L for current period and YTD with comparisons to budget and actual. This report takes up to 5 minutes to run. They need the unit sets so they can drill down into each location. Does anyone else have clients with a number of units set up that experience similar report generation times? They would like to know if that is a typical response time due to the number of units they have. If we run the report with out the unit set then it generates in a few seconds so it definitely seems to be tied to the unit set. Does anyone have any experience in structuring unit sets so they run more efficiently?
Thanks,
Jean
I haven't tried that many lines in a Unit Set but the performance you are seeing doesn't seem that surprising to me. From what I can tell, it has to run the report for each node of the Unit Set so the report results are all there and available for when you start clicking through and filtering on specific Unit Set lines.
I remember adding logic to do lazy loading of the unit sets in ARM back in 5.3 so that we didn't have to run the report for every single unit. If your unit is a folder that aggregates every unit below it the optimization will not work. A flat unit tree structure (every branch as a separate unit) is what you need. Note that you can have a unit that includes every branch, that will also work as long as the "ALL" is not a folder or group above all the child units.
P.S. if you haven't seen it yet, check out Velixo Reports at www.velixo.com - it's an Excel-based financial reporting tool for Acumatica that brings the power of ARM to Excel - there are many large scale customers using it for multi-branch/multi-company reporting and performance is good.
Thanks for chiming in Gabriel. No one knows more about ARM than you. And your Velixo Reports application is awesome. Great way to put it: bringing the power of ARM to Excel.
Online Members
