megaphone
Update your Profile with your Support type to get your Support Type badge.
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.
Don't miss out on our Question of the Week ! You only have until tomorrow, March 12, 2026, 2:00PM ET to comment your answers.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here!
What Topic Should We Cover Next? Your idea could be our next feature—drop your suggestion now!
No Limits. Just possibilities. Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Discover what's next at SuiteConnect Tour 2026.
Try Intelligent Payment Automation – Fee Free For Your First Month For more information, visit this thread.

Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!

Selected Max Line Item Only

edited Jan 3, 2020 12:59AM in Search / Reporting 1 comment

Just when i start to somewhat enjoy NetSuite Searches I run into this.  I am working on a search that I am trying to pull last income message from a quote.

Transaction Search Criteria

 Type: Quote  Status: Open  Main Line: True  Message Fields...Is Incoming: True

Criteria Summary
 Results[html]  Company(Name)  Document Number  Amount  Message Author  Message Subject   Days Open


I have tried so many combinations of Max and Group and custom case formulas and summary criteria in order to get the right results. I have also tried from message search and pull in the quote information.

One there has to be an easier solution! Two, it keeps pulling wrong results.  Even when I have the criteria as is incoming, it is pull messages that are not incoming, they are outbound.  When I use max message date, group by transaction it should pull what I want (or I believe it should).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

Community Whiz

Quarter 1 (Jan-Mar 2026)

This Week's Leaders

This Month's Leaders

All Time Leaders