AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

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

Forums
AUG Forums
Acumatica Generic I...
Generic Inquiry - S...
 
Notifications
Clear all

Questions Generic Inquiry - Select Data based on Max Total Aggregate Function

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Dominic Boullé 2 years ago
4 Posts
2 Users
1 Reactions
1,103 Views
RSS
wpratley
Posts: 5
 wpratley
Topic starter
May 3, 2024 9:31 am
(@wpratley)
Active Member
Joined: 5 years ago

Hi,

 

I have a GI that provides data for GL ending balances.

The request is to show data for all open periods and the max of last locked.

I can display the max value but I am stumbling on how to get the data to only show if it matches that value.

Any thoughts?

Do you think I need to create a View and do a Union statement to achieve this?

I would be ok with 2 separate GI's - one for all open periods and one for Max Locked.

TIA

 

 


3 Replies
Dominic Boullé
Posts: 17
 Dominic Boullé
May 8, 2024 8:09 pm
(@dboulle)
Eminent Member
Joined: 2 years ago

Hi wpratley, I do have an idea on how this could be achieved, could you please share your GI so can have a better think on it?


Reply
Tim Rodman reacted
wpratley
Posts: 5
 wpratley
Topic starter
May 15, 2024 2:20 pm
(@wpratley)
Active Member
Joined: 5 years ago

Hi Dominic,

 

I'm unable to upload an xml file here.

I think I may have found a workaround for now.

I really appreciate the response.

 

Thank you.


Reply
Dominic Boullé
Posts: 17
 Dominic Boullé
May 15, 2024 5:18 pm
(@dboulle)
Eminent Member
Joined: 2 years ago

No worries, hope it works well for you...

I was just meaning screen shots of the GI structure 🙂


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,528 Topics
  • 10.9 K Posts
  • 6 Online
  • 2,412 Members
Our newest member: Peter Paasch
Latest Post: Credit Reference Report Needed
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

  • Tim Rodman
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×