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!
Finding Largest Sale Amount and Date of Sale
I'm trying to build a transaction search to find both the date and the amount of the largest sale for each customer. An additional wrinkle is that I need only the last such date if there happens to be more than one sale for the same amount to that customer. Is there a way to do this? (We kept accumulators for this information in our legacy system, but aren't planning to in NetSuite. We go live on Monday.)
I can find the largest amount and/or the most recent date, but need to restrict the date to be for the sale that had the largest amount.