So it’s been a week since I temporarily abandoned the Acumatica Data Access Classes (click here to see what I mean). This is just a temporary thing and I’m sure that there is a better way to learn this, but I decided to take the blunt approach by hunting around the Acumatica database to see if I can get comfortable with how things are related. That’s right, no Acumatica University (click here), no help pages, no glossy manual, just me out in the cold alone with the Acumatica database.
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 option is to report directly on the database so this is what I’m used to. [Read more…]