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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
What is the Best way for honing a Transaction search view to only one line per 'deal'?
Hello gurus!
I'm trying to build out some offline lead attribution modeling, and I'd like to feed it with a succinct report containing underlying data for Transactions. But the catch is, I really only want the single most relevant Transaction per deal related to the sales workflow, regardless of what Type it is.
That is, when I view results of a custom Transaction search, and I limit the Type to Opportunities, Quotes, and Sales Orders, I get every row related to the progression of a final order. Very specifically, for example, I'll get one row for the Quote and another row for the Sales Order - same 'Amount' on both. Obviously, the Quote becomes irrelevant once there's a corresponding Sales Order. I think..