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...]
Acumatica Blog
Acumatica is an exciting Cloud ERP product and this is my personal Acumatica Blog. Feel free to contact me with any Acumatica questions that you might have.
Acumatica Standard Reports: GL Reversing Batches
This post is part of a two year series of posts related to the out of the box reports in Acumatica. For a full list, click here. The GL Reversing Batches (GL690010) report in Acumatica allows you to enter a batch and then see all the reversing entries that have been made against that batch, including their individual debits and credits. This isn't my favorite report, but I suppose it could come in handy when you aren't sure if there have been any reversing entries made against a … [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...]
Acumatica Standard Reports: Open GL Documents
This post is part of a two year series of posts related to the out of the box reports in Acumatica. For a full list, click here. The Open GL Documents (GL656000) report in Acumatica allows you to view all the unposted GL documents in Acumatica. It's easy to forget about an unposted transaction. This report helps you to track them down and clean them up. Screenshots Here are some screenshots from the report: … [Read more...]
Acumatica Standard Reports: GL Recurring Transactions Detailed
This post is part of a two year series of posts related to the out of the box reports in Acumatica. For a full list, click here. The GL Recurring Transactions Detailed (GL640500) report in Acumatica shows your recurring transactions that have been setup in the Recurring Transactions (GL203500) screen. It is very similar to the GL Recurring Transactions (GL641500) report except that it shows the individual debits and credits for each scheduled batch. Screenshots Here are some screenshots … [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...]
Acumatica Standard Reports: GL Recurring Transactions
This post is part of a two year series of posts related to the out of the box reports in Acumatica. For a full list, click here. The GL Recurring Transactions (GL641500) report in Acumatica shows your recurring transactions that have been setup in the Recurring Transactions (GL203500) screen. Screenshots Here are some screenshots from the report: … [Read more...]
Acumatica University – Now Available to All
Great news for Acumatica fans. There is a new website for Acumatica University and it's open to everyone. Joel Gress has a nice write-up about it (click here). To access, just go to AcumaticaOpenUniversity.com. I have to say that this move by Acumatica doesn't surprise me at all. It is consistent with the "we have nothing to hide" company culture that I have been observing since April 2013. Acumatica has an "open" philosophy. You can open any screen and see the code behind it without having … [Read more...]
Acumatica Standard Reports: GL Register Detailed
This post is part of a two year series of posts related to the out of the box reports in Acumatica. For a full list, click here. The GL Register Detailed (GL621000) report in Acumatica shows your all the batches in the system that have been Posted or Released, regardless of the module. The format of the report is almost exactly the same as the GL Edit Detailed report, except the GL Edit Detailed report shows batches that have not been Posted, Released, or Voided whereas the GL Register … [Read more...]
- « Previous Page
- 1
- …
- 41
- 42
- 43
- 44
- 45
- …
- 60
- Next Page »