Wow, I can't believe that it's been two months since my last substantial blog post! But it is Summertime and family activities take priority over the blog. We did some camping, made a trip to California to see family, and have generally been having a blast enjoying the nice Summer weather. Now it's time for a long overdue blog post. Two months ago we built a very simple example of a dashboard in Excel (click here). Since we built it from an Acumatica OData connection, we were able to … [Read more...]
Microsoft Excel Dashboards in Acumatica ERP
Last week we built a very simple dashboard in Excel by connecting Acumatica data to Excel using OData. This week I have been super busy so I wasn't able to put together a video post. However, I did find a couple of helpful links that demonstrate the power of Microsoft Excel Dashboards in Acumatica ERP: … [Read more...]
Building a simple Dashboard in Excel using Acumatica ERP OData
Easy to Use and Massive Community There is a reason that Microsoft Excel is the world's most popular BI reporting tool. It's easy to use and you can find tons how-to information online. If you aren't sure how to do something in Excel, just type your question into Google and the chances are that you will find an answer. Excel formulas are very powerful and there are myriads of ways that you can combine them together to create powerful calculations. … [Read more...]
Connecting to Acumatica data from Microsoft Excel
Update February 5th, 2017: Alas, the TryAcumatica.com links don't work anymore since that site has been taken down. So, I removed the links. Last Week Last week we took a look at how to build a simple Generic Inquiry screen in Acumatica. Then, at the very end, we checked a box to enable it for OData. Checking that box allows us to connect to the data in our Generic Inquiry screen using other applications, including the world’s most popular business intelligence application: Microsoft Excel. … [Read more...]
Creating an OData Connection by building a Generic Inquiry screen in Acumatica ERP
Two weeks ago I posted about why it’s such a big deal that Acumatica has connected to Microsoft Excel and Power BI via OData. But how do we tap into this new magic “power”? Everything begins with building a Generic Inquiry screen in Acumatica. In order to use an OData connection in Acumatica, you first have to build a Generic Inquiry screen. In this post, I’d like to walk through building a simple Generic Inquiry screen and enabling it for OData. … [Read more...]
Acumatica Reports – Report Designer (5%) and Excel / Power BI (95%)
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...]
Acumatica Connects to Microsoft Excel and Power BI with OData
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...]
Excel Reports: A Glimpse Into Future Acumatica?
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...]
Ohio Trending Upward: Acumatica, Lebron James, the Republican National Convention, and Microsoft Excel
I was planning to do a post this week on the email features in Acumatica, but the announcement by Lebron James last Friday was such HUGE news here in Cleveland that I thought this post would be better. I’ll pickup the email features post next week. … [Read more...]
Week 3 – Out in the Cold With the Acumatica Database
After taking a detour last week and exploring how to add new fields to existing screens in Acumatica (click here), I decided to return to the task of learning to create Excel reports that point directly to the Acumatica database. I began with this idea three weeks ago (click here) and continued two weeks ago by taking some baby steps to create a very simple Excel report (click here). This week I decided to pickup with where I left off a couple weeks ago and attempt to continue reproducing the … [Read more...]