Currently, you can’t build Microsoft Excel reports in Acumatica. However, if Acumatica implements OData in the future, this will become a possibility. In the meantime, I created a simple Excel report as an example of the powerful things that you can do with Excel. This report was built for Sage 500 and is being sold through The Report Store (click here), but it would look exactly the same for Acumatica if the OData option is included at some point. So, maybe this is a glimpse into future … [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...]