When using the reporting tools in Acumatica, Microsoft Excel often gets overlooked. I used to hate Microsoft Excel, but now I love Excel. … [Read more...]
My Journey From Hating Excel to Loving Excel (Part 1)
When using the reporting tools in Acumatica, Microsoft Excel often gets overlooked. I used to hate Microsoft Excel. … [Read more...]
Acumatica Comma-Separated List of Purchase Orders for a Vendor using Velixo Reports
You can use Velixo Reports and Acumatica to get a comma-separated list of Purchase Orders for a list of Vendors. … [Read more...]
Acumatica Comma-Separated List of Purchase Orders for a Vendor using Microsoft Excel
You can use Microsoft Excel and OData in Acumatica to get a comma-separated list of Purchase Orders for a list of Vendors. … [Read more...]
Query Quarry for Acumatica ERP
Query Quarry for Acumatica ERP helps you get started with Acumatica Generic Inquiries, Pivot Tables, Dashboards, Business Events, & Excel / Power BI OData. … [Read more...]
An Announcement (Part 2)
Seven weeks ago I started working for Acumatica. During the past seven weeks, I have been considering whether or not to continue posting on this blog. I have a lot of ideas for posts (some written down, some in my head), but I wanted to see how the first seven weeks would go as an Acumatica employee before deciding whether or not to continue blogging here. Here is what my Evernote blog post ideas document looks like at the moment: Power BI Top 5 Customers by Revenue Creating a data … [Read more...]
Of Acumatica and Power BI – A Tale Loosely Inspired by the title of a classic novel by John Steinbeck (Guest Post)
Guest post by Brad Kostreva Quick intro from Tim: I was thrilled when Brad asked me last month about doing some guest posts here on the blog. We first connected about a year ago through the blog and have kept in touch ever since. I mentioned him recently on the bottom of the What is Power BI post. Unlike me, an Acumatica reporting hobbyist, Brad is actually using Acumatica, Excel, and Power BI in the real world. I'm looking forward to hearing his real world experiences in this and future … [Read more...]
An Announcement
Tomorrow, September 17th, I will become an employee of Acumatica, filling the ERP Solutions Consultant position in the Columbus, OH office. I announced this on LinkedIn last week Acumatica has been a fun side project / hobby for me since April 30th, 2013. But I'm happy that I will now be working with it full-time. Of course, I'm also happy that I will now be getting paid too :) Am I Excited? … [Read more...]
What is Power BI?
Many of you have seen the news about Acumatica connecting to Power BI from a few months ago (click here, here, and here). Currently, Acumatica is the only ERP product listed on PowerBI.com: But Power BI is a fairly new thing and many people aren't exactly sure what it is. So, in this post I'll attempt to answer the question, "what is Power BI?" … [Read more...]
Try Excel Online For Free
The Current Excel Online Problem Three weeks ago we looked at using Excel Online to deliver your awesome Excel reports to people without them having to know that you made it in Excel. However, there currently is a problem with Excel Online. The problem is that there are actually different versions of Excel Online. There is a Free version, there is a Business version, and there is an Enterprise version. For more details, checkout this post by Mike Alexander (click here). I personally do … [Read more...]