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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
saved search formula error
Hi
I am trying to create a saved search with record type as item fulfillment and item receipt. i want the last shipped date of an item and first received date for an item.
so following is set on saved search.
In criteria
type = item fulfillment, item receipt
main line = false
In results
item field with groupby summarization
formula(text) maximum case when {type}='Item Fulfillment' then {trandate} else '' end
it gives me error invalid expression.
within single item i want dates in two different columns in first column it will show last fulfillment date and in another column it will show first received date for that item.
0