Converting Comparative Generic Inquiry into Report (in Report Designer)
Greetings to all,
Hope you are having a great day.
I've created a Generic Inquiry in Acumatica to show our Daily Sales, Monthly Sales and Yearly Sales and the same for Last Year, this is how it looks:
However, I decided to replicate this Inquiry in Report Designer, to be able to use date parameters, and have a total at the end to sum up company sales. I've tried several methods. First time I tried modifying an existing report (AR67300) and try to adjust it to our needs, but it didn't work. After that, I decided to create a new report from scratch based on the Generic Inquiry formulas, but it still didn't work. Lastly, I decided to export the inquiry as a report and started working from there. However the results, even with the same formulas are different:
I'd like to know why this happens, even though I have the same scheme, tables, relations and formulas. I'm attaching a copy of the .rpx so you can take a look at it and suggest new options. Thanks in advance for you input!!
Gustavo R. Carrasquillo