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!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
How to create a Saved Search to show the earliest Payment Date?
Hello, I have created a report based on transactions showing all the payments ever received.
I want to show in ONE line: the earliest payment date and the total amount paid (meaning that I will have the sum the amount of all the payments (if there were many) for a transaction and see only one earliest payment date.)
At the moment, I have multiple lines per payment that were made in my saved search.
Also, note that my report contains multiple formulas (percent, currency); therefore, I cannot use "Summary type" for all.
Is there a way to get this result?
Tagged:
0