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...]