AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • 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

  • acuCONNECT 2025 – Visualizing Inventory Balance $ and Service Level % TOGETHER September 19, 2025
  • EP 157: acuCONNECT 2025 Preparation – Part 4 (Podcast) September 16, 2025
  • EP 156: acuCONNECT 2025 Preparation – Part 3 (Podcast) September 6, 2025
  • EP 155: Chris Hackett – Update on Acumatica User Groups (Podcast) August 26, 2025
  • EP 154: acuCONNECT 2025 Preparation – Part 2 (Podcast) August 5, 2025

Recent Forum Posts

  • Travis

    RE: Pick List report suddenly not splitting on Shipment

    I never found a solution initially - here I am 3 years ...

    By Travis , 2 weeks ago

  • ToonSix

    RE: Feeling Stuck on Making a Sandbox of our Database

    Delete as many snapshots as possible before making a ne...

    By ToonSix , 2 weeks ago

  • Retha

    RE: Printing Product Labels from Purchase Receipt

    I have read the article on the How to print multiple pr...

    By Retha , 3 weeks ago

  • Paul Lambert

    RE: Generic Inquiry into Business Event to monitor Import Scenarios

    An idea I've been brainstorming and haven't yet tested ...

    By Paul Lambert , 3 weeks ago

  • Jacky Mao

    How to make Customer Class ID available in Business Events for AR302000 (Payments and Applications)

    Hi everyone, I’m trying to create a Business Event fo...

    By Jacky Mao , 3 weeks ago

  • Lunar Windbloom

    Feeling Stuck on Making a Sandbox of our Database

    Hi all! Hope your day is going well! It's finally the...

    By Lunar Windbloom , 1 month ago

  • Tim Laird

    RE: [SOOrder.Status] = 'Open' always returns false

    @russ Customer Classes are user maintained, so you setu...

    By Tim Laird , 1 month ago

  • Tim Laird

    RE: What Triggers a Customization to need a Restart?

    OK, one more update. This creeped up again this weeken...

    By Tim Laird , 1 month ago

  • russ

    RE: [SOOrder.Status] = 'Open' always returns false

    This trick doesn't seem to work anymore. At least not ...

    By russ , 1 month ago

Terms of Use & Disclaimers :: Privacy Policy

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