By using this website, you agree to our Terms of Use (click here)
Does anyone know of a way to have the XLS download function open an XLS file where each of the individual results in the Acumatica report, such as an Aged Accounts Receivable, run for all branches, and resulting for instance in 10 separate reports within the results, can be downloaded to XLS where each of the individual results will be included on separate named tabs?
You could build the Excel file with OData so it could all be refreshed at the click of a button. You could even schedule it to be run automatically using Power Update (click here).
Another option is BI360 (click here), especially if you need the tabs to be generated dynamically automatically depending on the number of Branches that exist at the time that the report is run. BI360 has an Excel tool that allows you to do this.
Online Members
