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.
Year by Year Comparison
I need to make a saved search which looks at a year by year comparison for customer sales. The stock reports I've seen that show this don't include shipping cost, which we'd like to include. In addition, there are more columns I need to add that I don't believe will be possible using a report vs a saved search (value if type is a credit memo, value if type is an invoice, etc.).
Here's what I have right now:
CASE WHEN ({transaction.type}='invoice' and {transaction.trandate} > to_date('01/01/2014','MM/DD/YYYY') AND {transaction.trandate} < {today}) THEN {transaction.amount} END
0