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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
How to create a Customer Saved Search combining Sales Order and Quote Items?
Curious if anyone knows of a formula that I can use on a Customer saved search that will give me a customers:
Last Order Date = Formula (Date) | Summary Type: Max | Formula: case when {transaction.type} = 'Sales Order' then {transaction.trandate} else null end
Last Item Ordered:
Last Quote Date = Formula (Date) | Summary Type: Max | Formula: case when {transaction.type} = 'Quote' then {transaction.trandate} else null end
Last Item Quoted:
Trying to make 1 search instead of a Sales Order search and a Quote search.
Tagged:
0