AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Consulting
  • Courses
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Converting Comparat...
 
Notifications
Clear all

Converting Comparative Generic Inquiry into Report (in Report Designer)  

    Last Post
RSS

Gustavo Carrasquillo
Posts: 35
 Gustavo Carrasquillo
September 4, 2020 5:04 pm
(@gustavo-carrasquillo)
21-50 Posts
Joined: 7 months ago

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:

Screen Shot 2020 09 04 at 1.09.48 PM

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:

Screen Shot 2020 09 04 at 1.30.07 PM

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

TodayComparativeSales.rpx

 

 

This topic was modified 4 months ago by Tim Rodman
3 Replies
Tim Rodman
Posts: 2488
 Tim Rodman     ★★ All-Star ★★
October 9, 2020 5:20 pm
(@timrodman)
Over 200 Posts
Joined: 5 years ago

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?

This post was modified 4 months ago by Tim Rodman
Reply
Gustavo Carrasquillo
 Gustavo Carrasquillo
(@gustavo-carrasquillo)
Joined: 7 months ago

21-50 Posts
Posts: 35
October 13, 2020 10:49 am
Reply toTim RodmanTim Rodman

@timrodman yes I am still needing this in Report Designer! Here's the XML:

 

Daily Sales - Comparative.xml

 

Thanks for your reply. 

Reply
Tim Rodman
 Tim Rodman
    ★★ All-Star ★★
(@timrodman)
Joined: 5 years ago

Over 200 Posts
Posts: 2488
January 24, 2021 1:59 am
Reply toGustavo CarrasquilloGustavo Carrasquillo
Tim Rodman

@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:

image

 

You might try moving your formulas to detailSection1 to see if you get any results.

Reply
  All forum topics
  Previous Topic
Next Topic  
  Forum Statistics
11 Forums
1,656 Topics
7,693 Posts
1 Online
1,110 Members

Latest Post: Timecard reports/queries Our newest member: Janetteraab Recent Posts Unread Posts

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×