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...]
Acumatica Excel Reporting–Two Options–BizNet BizInsight vs. Solver BI360 (part 1 of 2)
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...]
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...]
Lesson Learned: Don’t Abandon the Acumatica Data Access Classes (DAC)
Ok, I give up. Exactly one month ago (click here) I attempted to abandon the Acumatica Data Access Classes. Now, at the time I wasn’t sure if it would work out, but I thought I’d at least try it temporarily. One month later and I’ve given up. I feel like I need to go to a chalkboard and write “Don’t abandon the Acumatica Data Access Classes” over and over again. … [Read more...]
Temporarily Abandoning the Acumatica Data Access Classes
I still have a lot of hope for learning how the Data Access Classes in Acumatica can contribute to better reporting. As far as I can tell, I think the Data Access Classes function like the Acumatica Reporting??? side of the picture below. However, I think that I'm going to revert to my comfort zone for a little while to see how well I can create reports directly against the Acumatica database like in the Traditional Reporting side of the picture below. In more traditional ERP systems, your only … [Read more...]
Acumatica, Power Query, and Power Pivot
I wasn't able to spend much time on direct Acumatica learning this week, but I did get to entertain an Excel reporting idea that I think would be very powerful if I can get it to work. First, a word about Power Pivot. I began using Power Pivot early last year and have become a big fan. At my company, we now do a lot of our reporting in Power Pivot. Recently, over the past few months, I have been attending the Cleveland Excel User Group which focusses on Power Pivot and is organized by a guy … [Read more...]
Acumatica Reporting Model?
I have to admit, at first I was disappointed to learn that Acumatica has its own reporting program. I was hoping that Acumatica would leverage SQL Reporting Services (SSRS) rather than create its own standalone report designer. The reason is that there is already so much functionality built into SSRS. I didn't see why Acumatica would reinvent the wheel. I don't know the technology behind SSRS that well so I don't know much about what would have been required to integrate it into the Acumatica … [Read more...]