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
Can you also attach the XML export of the Generic Inquiry for comparison purposes?
It looks like you were able to add totals to the Generic Inquiry using this post:
Does that mean you no longer need to do this report in Report Designer?