NetSuite Saved Searches: A Complete Guide

in , October 26th, 2022

If you're a NetSuite user, you know that there are a lot of features to explore. One of the most useful is Saved Searches. This article will look at Saved Searches and show you how to create and use them. We'll also provide tips on getting the most out of this feature.

What is a Saved Search in NetSuite?

NetSuite is an excellent platform for managing your company data from one centralized location. One of the best features to manipulate and use the data housed in your NetSuite account is a Saved Search. A Saved Search is an excellent reporting tool used in NetSuite, which allows you to surface very specific data.

NetSuite Saved Searches are easy to set up and can benefit companies in a wide variety of use cases:

  1. Monitoring Tool: A Saved Search can be added to your NetSuite dashboard in a portlet, allowing you to keep important up-to-date information right in front of you. You can even use a saved search to visually track progress toward a goal.
  2. Flexibility: It's easy to change criteria and add filters, and you can even add the highlighting rules to manipulate data and see the important stuff.
  3. User-friendly: It's not hard to learn how to use a saved search, and it is not hard to learn how to build a safe search. And it's something you can learn within a few hours, which is excellent.

How to create a Saved Search in NetSuite?

Note: To create a Saved Search in NetSuite, you have to log in as an administrator. If you do not have the proper access and permissions to create a Saved Search, contact your system's administrator.

To create Saved Searches in NetSuite, you will begin by navigating to Reports > Saved Searches > All Saved Searches > New.

NetSuite Saved Search navigation

Once you click on the new Saved Search tab, it will show you a list of all the available Saved Search Types. For this demonstration, we will create a Saved Search to show bill payments and the corresponding Bill and purchase order relating to that bill payment. Given his use case, we will select the 'Transaction' type for our Saved Search.

NetSuite Saved Search Type

This will open a page titled 'Saved Transaction Search', where you will set the parameters for the Saved Search.

Note: Notice that our page title here, "Saved Transaction Search", matches the "Transaction" search type we just selected. If you are creating a different type of Saved Search, just keep in mind that the page title will reflect this difference.
NetSuite Saved Search form

Set a Title, ID, and Basic Access/Display Preferences

The first thing you want to do is enter a search title. So, this one will be "Bill Payments- Corresponding PO and Bill."

NetSuite will automatically set an ID for your saved search if you do not create one. However, we recommend assigning an ID manually so you can make it easily recognizable.

Note: A best practice when creating an ID in NetSuite is to begin the ID with an underscore since a standard prefix (ex. "customsearch") will be automatically added to any NetSuite ID you create. In our case, if we set the ID to "_bill_payments_PO_and_bill" the full ID with the prefix will be "customsearch_bill_payments_PO_and_bill".

If you want your Saved Search to be available for all users, mark the 'Public' checkbox. To have this saved search available as a list view so that you can display, for example to display it as a list in a portlet on your dashboard, you will also need to mark the 'Available as List View' checkbox.

NetSuite Saved Search title

Define the Criteria for Saved Transactions Search

Criteria are all the rules you set to ensure that the data within NetSuite is configured so that you only see the information you want in your results. For example, if you were to run a Transaction Saved Search without setting criteria, the search would return all the transaction records in NetSuite. We don't want that, so we will restrict the Saved Search results using a few options on the Criteria Tab.

Define the Type in Criteria

The first thing you need to do is further define the type of transaction you want the saved search to return. On the Criteria tab on the Filter subtab, you can find Type.

Note: This is different from the Saved Search Type (in this case "Transaction") that you selected in a previous step. The Saved Search Type defines what types of records the saved search will consider, apply criteria to, and return as results for (in this case, transaction records). On the other hand, the "Type" filter selection under the criteria tab, which is being adressed here, allows you to further restrict the results of the saved search by specific types of transaction records, (in this case bills payments).


NetSuite Saved Search Criteria

Once you select "Type", you'll see a popup with a complete list of all the transaction types in NetSuite. So as mentioned before, we'll be looking at bill payments. So, we are just going to select bill payment as the type. Once you have selected the type(s) of transaction you want the saved search to return in its results, click 'Done' and then click 'Set'.

NetSuite Saved Search transaction search type

So now your Saved Search will only return transaction records that are bill payments.

Specify the Main Line Criteria

One essential thing when coming to transaction searches is the Main Line criteria. Main Line refers to the header line of a transaction, which appears above all the line items. If you are interested in only the Header information, you want to set the Main Line option to ''yes". But in this example, we will leave this marked as "no" since we want it to return all of the line items.

NetSuite Saved Search main line criteria

Select the Date Range

You can put as many criteria as you want here. For example, you might also be interested in a date, and you can select a date range of your choice.

NetSuite Saved Search date range

You can type the date range straight into the 'From' and 'To' fields, or you can open the quick filters and use them to find available dynamic date ranges such as "this year" or "same week last fiscal year".

NetSuite Saved Search dynamic date range

Specifying the Related Records

When you look at your filters list, you'll notice there are ellipses after some of the options, which indicate that these are drill-down fields. In this example, our Saved Searche can investigate or return data from related records of the bill payment.

NetSuite Saved Search related records drill down fields

Now, what's a related record? For example, if you look at a Sales Order, you can see a customer record associated with it and item records. These records are not on the sales order; they are separate records in the system associated with the sales order.

Load the Results

Once you've set the criteria, it's time to move to the results tab. You've got some sorting options at the top of the Results Tab. These allow you to sort the results that are returned by up to three parameters, each in ascending or descending order.

NetSuite Saved Search results rules

On the Results tab, there is a Columns subtab. Under the columns, you will see 'Fields'. This is where you will set up the columns to be included in your report by adding any/all fields for which you want to see information.

NetSuite Saved Search results column configuration

Under columns, the first thing I want to put is the date.

Next, I'll enter 'Paid Transaction', which will result in a column with information on the paid bills.

Then, we want one column to return information on the purchase order from which the bill payment was created. So, using that related records feature mentioned before, you can go to paid transaction fields:

NetSuite Saved Search paid transaction fields

And then, you can dig into that related record information. In this case, you want to add a "Paid Transaction: Created By" column, which will return information on the POs that these bills were created.

NetSuite Saved Search created from column

I am also interested in the amount paid, the document number, and the payee's name. So I will add all those as columns; I now have six columns on the report.  

NetSuite Saved Search result columns

Once you have set the fields that you want returned as columns, you can adjust the Header labels for each column using Custom Labels.

NetSuite Saved Search custom column labels

In this example, you can see that we changed "Paid Transaction" to display "Bill Number" in the header instead since that will make more sense in the final report based on the criteria we set for the search results. For that same reason, we also changed "Paid Transaction: Created By" to "PO Number"; changed "Paid Amount" to "Amount Paid"; changed "Document Number" to "Check Number"; and changed "Name" to "Payee".

Highlights, Available filters, Audience, Roles

There're some additional features here where you can set your highlighting rules, your available filters, audience, roles, and email.

NetSuite Saved Search highlighting rules

Highlights

Highlighting enables you to highlight specific results. For example, you might be interested in bringing special attention to transactions above $10,000. You can set your condition and then highlight the requirements.

Available Filters

An available filter will show at the top of your report when you run it, allowing you to narrow the results. I will select 'Name' for this use case because I'm interested in filtering between payees once the Saved Search returns the results. Be sure to select the 'Show in filter region' checkbox if you want the filter to display at the top of the report.

NetSuite Saved Search available filters

Audience

Under the Audience subtab, you can define who in your NetSuite account can see this Saved Search. In many cases, it makes sense to set a Saved Search as 'Public' so anyone with access to your NetSuite Account can benefit from it and doesn't accidentally re-create a saved search you already worked to build.

However, if you would like to restrict who has access to the saved search, you can define this using Roles, Departments, Subsidiaries, Groups, Employees, and more. For example, if you wanted only to allow members of the accounting team or the A/R or A/P team access to this report, you can use roles to define this access.

NetSuite Saved Search audience

I will select 'Public' for our use case, so everyone has access.

Run the Report

We are ready to run the report. So click the 'Save' button, and it will start running the report. It might take a little time to load all the results you have available in your system.

create your NetSuite Saved Search

How to Export a Saved Search in NetSuite?

You can export this information as a csv, excel, or PDF file, and do quite a lot of manipulation to the data to pull a report for the information you need.  If you want to export your Saved Search report, click on that report, and you will see at the top left some icons that you can use for exporting. And what you have to do is click on the icon to download the files.

netsuite saved search results export options
Note: You can also add Saved Searches to your NetSuite dashboards

NetSuite Alliance Partner & Commerce Partner

That's it for our NetSuite Saved Search tutorial! We hope you found this helpful and that you can now use Saved Searches to manage your business processes with NetSuite. If you have any questions about NetSuite or how it can benefit your business, contact us! Anchor Group is a certified Oracle NetSuite Alliance Partner & Commerce Partner, and is equipped to handle all kinds of NetSuite and SuiteCommerce projects, large or small!

anchor group oracle netsuite alliance partner commerce partner
 
 

Want to keep learning?

Our team of NetSuite professionals here at Anchor Group has written articles on a wide variety of NetSuite topics, from SuiteCommerce tips, to recommended NetSuite solutions, to available support services, and more! 

Your cart
    Checkout