By using this website, you agree to our Terms of Use (click here)
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!!
Happy learning,
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:
https://www.augforums.com/forums/acumatica-generic-inquiries/add-total-to-a-gi
Does that mean you no longer need to do this report in Report Designer?
@gustavo-carrasquillo One thing that looks funny to me is that your formulas are in groupFooterSection3 (Footer of Division), but the Division group doesn't have any fields in it:
You might try moving your formulas to detailSection1 to see if you get any results.