Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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?