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 can I compare fields in different records within a search?
I am trying to create a search that will count all open quotes and total their value. That part is easy enough to do, the problem is, multiple quotes may go out to different contractors (customers) for the same job, with only 1 of the multiple quotes completing. Another situation may be where one contractor requests multiple quotes for different versions of the same product. We would like to make this search as accurate as possible and would like to remove duplicate quotes. How can I compare a field in one quote to that field in all the other quotes and see if there is a more quotes with the same value?