RE: Saved Search Formula

Looking for resources/examples to create a saved search which pulls the current QTD, Prior Quarter, etc for last 5 quarters. Anyone have good examples of formulas or a sequel resource

Note – I don’t understand SQL but get the concepts of case when etc

KPJ Rookie Asked on October 29, 2019 in Saved Searches.
Add Comment
2 Answers

This SuiteAnswers article:

SQL Expressions


Published 03/04/2011 12:24 PM   |    Updated 09/16/2019 10:37 AM   |    Answer Id: 10101


Also, the Database SQL Reference:  (You can also just google for the specific function you’re looking for and the specific page you want from this is usually one of the top few results).  Not all of the functions in here are guaranteed to work in NetSuite, so the SA article is the best to stick to if you can make those work, but most of these do work, so if you’re really finding the SA choices limiting, this is a good reference.


For specific examples, I would search SuiteAnswers for what you’re looking for using “saved search formula” keywords.
Intermediate Answered on October 29, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.