When I modify a report using the Acumatica Report Designer, I personally like to open the report directly from the server. Then I don’t have to download a copy and then upload my new version. However, when I first tried to use the File -> Open From Server… option, which looks like this: … [Read more...]
My Acumatica Wardrobe Change: From “Acumatica Hobby” to “Acumatica Reporting Business”
Acumatica Hobby Up until today, this was my approach towards Acumatica: Last week was the 1.5 year anniversary for this blog and my personal Acumatica learning journey (click here). That milestone, coupled with a rejuvenating two week vacation, caused me to consider where I would like to go next. Up until now I have considered Acumatica to be a hobby. But, while on vacation, I decided to take this thing to the next level: from “Acumatica Hobby” to “Acumatica Business”... … [Read more...]
Acumatica Dashboards, Reports, and Inquiries
This week I passed S130 Reports, Dashboards, and Inquiries. I first started this course back in July 2013 (click here). Now, almost a year later, I finally finished, thanks to a renewed interest in the Acumatica reporting vision (click here). Learning a new ERP product: An endurance race … [Read more...]
Project Quote Form
Michael Coman started a discussion on how to create a Project Quote form in Acumatica over on the Acumatica ERP Software User Group. I came up with something very simple which hopefully will be a good start. This was my first experience actually doing a real report/form with the Acumatica Report Designer. It definitely has a long way to go before becoming a user-friendly report designer like Crystal or SSRS. But, it is pretty flexible and, once you get the hang of it, it's not too … [Read more...]
Custom Vendors Report – Correction
I realized that my Custom Vendors Report was not correct. This was due to the Business Account concept in Acumatica. I'm still not sure of the reason for it, but there is an entity called a Business Account (BIZACCT) that is the parent entity for both Customers and Vendors. If you go to the Segmented Keys (CS202000) screen, you can see that both Customers and Vendors share the same parent entity, BIZACCT. What this means is that both customers and vendors store some … [Read more...]
S130 Reports Dashboards and Inquiries – Making Progress
I barely made it through the first 66 pages of the 112 page training manual on Acumatica Report Designer because it was really dry and boring. To be honest, I didn't read it carefully, but instead skimmed through. The concepts are consistent with other report writing programs like SSRS and Crystal Reports and the training material is more like a reference manual than training material. However, I do think that I will be referring back to it in the future since it's a good resource. For me, … [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...]
Using Acumatica Report Designer – First Time
The Acumatica Report Designer is a stand-alone program that allows you to create reports in Acumatica. Here was my first experience using the program. 1. Open the Report Designer program on the Windows Start Menu. 2. All reports are stored as an XML file with the extension .rpx. To open an existing report, you can go to File -> Open From Server... on the menu. 3. Enter the path to your Acumatica installation, then enter your login info. Note that, if you have multiple … [Read more...]
S130 Reports Dashboards and Inquiries
While I'm waiting for my appointment with the Acumatica Instructor, I decided to continue my learning journey by taking the S130 Reports Dashboards and Inquiries course. In my opinion, reporting is one of the main reasons why people buy new ERP systems. Sure, it's nice to have lots of information stored in your ERP system, but that information is only meaningful if you can create meaningful reports. Also, the S130 Reports Dashboards and Inquiries course is the only one that makes sense at the … [Read more...]