Currently, you can’t build Microsoft Excel reports in Acumatica. However, if Acumatica implements OData in the future, this will become a possibility.
In the meantime, I created a simple Excel report as an example of the powerful things that you can do with Excel. This report was built for Sage 500 and is being sold through The Report Store (click here), but it would look exactly the same for Acumatica if the OData option is included at some point.
So, maybe this is a glimpse into future Acumatica? I hope so
Here is a quick 5 minute video showing the report: