AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

Acumatica Reports – Report Designer (5%) and Excel / Power BI (95%)

May 5, 2015 by Tim Rodman

Last week I mentioned the recent announcement by Acumatica which connects Acumatica to Microsoft Excel, Power BI, Power Pivot, and Power Query. Then I made my case for why I think that Excel and the “Power” tools are a big deal. What about Report Designer? But where does the Report Designer in Acumatica fit into all of this? … [Read more...]

Filed Under: Acumatica Reporting Tagged With: Acumatica, Acumatica BI, Acumatica Blog, Acumatica Business Intelligence, Acumatica Excel, Acumatica Excel Connector, Acumatica Excel Reporting, Acumatica Learning, Acumatica OData, Acumatica Reporting, Acumatica Reports, Acumatica Reports in Excel, Acumatica Training, Microsoft Excel, Power BI, Power Pivot, Power Query

Acumatica Connects to Microsoft Excel and Power BI with OData

April 30, 2015 by Tim Rodman

Update June 4th, 2015 - Checkout my guest post over at PowerPivotPro.com Update May 6th, 2015 - Checkout my guest post over at OData.org Hold onto your seats, the world’s fastest growing Cloud ERP software (Acumatica) is about to collide with the world’s most popular Reporting and Business Intelligence software (Microsoft Excel). Acumatica made the announcement this morning May 01, 2015 (click here) at Microsoft Build, the annual conference aimed at developers who use Microsoft’s next … [Read more...]

Filed Under: Acumatica Reporting Tagged With: Acumatica, Acumatica BI, Acumatica Blog, Acumatica Business Intelligence, Acumatica Excel, Acumatica Excel Connector, Acumatica Excel Reporting, Acumatica Learning, Acumatica OData, Acumatica Reporting, Acumatica Reports, Acumatica Reports in Excel, Acumatica Training, Microsoft Excel, Power BI, Power Pivot, Power Query

Excel Reports: A Glimpse Into Future Acumatica?

October 9, 2014 by Tim Rodman

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 … [Read more...]

Filed Under: Acumatica Learning Tagged With: Acumatica, Acumatica Blog, Acumatica Excel Reporting, Acumatica Training, Microsoft Excel, OData, Sage 500 ERP

Acumatica Excel Reporting–Two Options–BizNet BizInsight vs. Solver BI360 (part 2 of 2)

September 11, 2014 by Tim Rodman

Last week (in part 1 of 2), I covered why I think BizNet BizInsight and Solver BI360 are important for Acumatica (click here). I currently work for a company that uses Sage 500 ERP and we were looking for an Excel-based reporting solution (BizNet BizInsight and Solver BI360 have the same functionality for Acumatica that they have for Sage 500 ERP). A colleague and I sat through demonstrations of both products and asked lots of questions. Based on that process, we chose Solver BI360 over BizNet … [Read more...]

Filed Under: Acumatica Learning Tagged With: Acumatica, Acumatica BI360, Acumatica BizInsight, Acumatica BizNet, Acumatica Blog, Acumatica Excel Reporting, Acumatica OData, Acumatica Solver, Acumatica Training, Power BI, Power Pivot

Acumatica Excel Reporting–Two Options–BizNet BizInsight vs. Solver BI360 (part 1 of 2)

September 4, 2014 by Tim Rodman

In this post (part 1 of 2), I’d like to cover why I think BizNet BizInsight and Solver BI360 are important for Acumatica. Next week, I’d like to give my opinion on which one I personally think is better and 5 reasons why. First, some background … [Read more...]

Filed Under: Acumatica Learning Tagged With: Acumatica, Acumatica BI360, Acumatica BizInsight, Acumatica BizNet, Acumatica Blog, Acumatica Excel Reporting, Acumatica OData, Acumatica Solver, Acumatica Training, Power BI, Power Pivot

By using this website, you agree to our Terms of Use (click here)
Building Generic Inquiries & Pivot Tables

Online Members

 No online members at the moment

Recent Blog Posts

  • EP 165: Jake Wells – EOS Scorecard and Acumatica Dashboards (Podcast) March 12, 2026
  • EP 164: Phil Steichen – Vibe Coding your own Business Intelligence tool (Podcast) February 19, 2026
  • EP 163: Daryl Bowman – Dissecting the new Acumatica Calendar Board (Podcast) February 9, 2026
  • EP 162: Gabriel Michaud – Catching up on new cool stuff in Velixo and Excel (Podcast) February 2, 2026
  • Acumatica Summit 2026 – Day 2 Keynote (Seattle, WA) January 27, 2026

Recent Forum Posts

  • Ed Dolan

    Negative/Credit Inventory Value?

    We are starting a new line of business to recycle const...

    By Ed Dolan , 24 hours ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodmanrodman Question for you. What table joins d...

    By Tami , 1 week ago

  • Brynn Rutherford

    RE: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min

    @timrodman - It won't let me attach the file. I will em...

    By Brynn Rutherford , 1 week ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodman Thank you! We just upgraded to 2025R1 in ...

    By Tami , 1 week ago

  • Tim Rodman

    RE: Production Orders with all material on hand

    @tlynn Looks like someone already created a product ide...

    By Tim Rodman , 1 week ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodman Yes! If that parameter was optional it wo...

    By Tami , 1 week ago

  • Tim Rodman

    RE: Can not delete an automated schedule

    I doubt it since Business Events are stored on the Busi...

    By Tim Rodman , 2 weeks ago

  • Tim Rodman

    RE: Production Orders with all material on hand

    Is the problem with this Critical Materials (AM401000) ...

    By Tim Rodman , 2 weeks ago

  • Tim Rodman

    RE: Update the Unit Rate for Existing Project Templates

    The following worked for me.   Here's the Data...

    By Tim Rodman , 2 weeks ago

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.