[nic kcd]

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

HTML Code:
Type: Quote
Status: Open
Main Line: True
Message Fields…Is Incoming: True
Criteria Summary[html]

Results

HTML Code:
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).

Would using Rank/Dense Rank SQL expressions get the desired results? I have used them yet, but feel maybe I should use them in the criteria summary results and create a custom formula there. Is that the right path? Any other solutions/thoughts?
This is a cached copy. Click here to see the original post.

[david.smith]

Try searching the messages, not the quotes. You can use the quote as criteria but I think you want the messages.

[Author]

Posts