Audaxium Blog

If there’s one thing you can spend some serious quality time with in NetSuite, it’s the searches.  It’s rare that I get a search challenge I can’t meet one way or another.  Because they are used to create custom KPI’s in NetSuite it’s a good idea to become familiar with all their in’s and out’s.

Here are some common tips I have for those who have moved beyond the basics of searching in NetSuite.

Selecting the Type

The first thing you do when you create a search in NetSuite is select the type of record you want to search.  It seems obvious and I won’t go through the long list of record types here.  You can search on any record type you want.  But here’s something to consider.  If you are doing a search that includes related records, carefully consider what record you might want as your starting point.  

Example. Are you looking for Opportunities with outstanding estimates attached?  Or are you looking for Opportunities attached to outstanding estimates?  There’s a difference and it will affect your results slightly.  In this case the one to many relationship will give you a different perspective.

The reason for this brings us to the next point…

Related Fields and Records

One thing I see NetSuite users miss regularly is the fact that you can search and filter records based on related records and information.  For example, if you log a call, that call record will typically be attached to the lead or prospect.  You can now search for leads and prospect that have been called by you, on a certain date, with a certain subject.

In the criteria tab, if you scroll to the bottom of the “filter” pulldown you’ll see related records with a “…” beside them.  Click and a box will pop up with fields from that record.  You can do this on both the criteria and results tabs. You can get very creative with this and really dig deep into your data. Experiment with this, make it your friend. 

Go Private

I’ve seen a few instances of NetSuite with hundreds upon hundreds of searches show up for users in both the “Menu” and in the list of public searches.  Most of these searches are wrong, irrelevant, or out of date. Do yourself a favor and don’t click the “public” check box and don’t click the “Show in Menu” check box on your saved search.  You’re just cluttering other users’ interface if you do and making it harder to find what they are looking for.

If you do want to make a search available to someone, just hop over to the audience tab, and select who should see it. Keep the menu reserved for very common and highly used custom searches.  Don’t make your admin clean up your mess for you.

(Remember that making searches public is a role permission, you might not have permission to do so.) 

Transaction Main Line

When searching transactions often people get confused as to what they are looking at, items on a transaction or the Header.  For example the amount on a line, and the amount of the entire transaction are different.  

For this reason you’ll see a “Main Line” field.  In the criteria you can set this to be true or false depending on what you want to see. 

In the results tab this field shows as the  * symbol.  If you are confused, put this field in the results and you’ll see which rows of your results come from transaction headers as opposed to the items they contain.

Result Summaries

One thing you’ll discover fairly quick is that when NetSuite shows search results it will show the same record multiple times for each time it’s found by the search.  For example you search for companies, and show, in the results, company name and call subject.  For each different call the company name will show on a new row.  If you’ve called the company 5 times, there will be 5 results rows.

For this reason you’ll want to use the “Summary Type” column to group things up, count them etc.  Get familiar with them. Once you use a summary you need to summarize each field you want to show in the search.

But here’s the real tip.  When you drill down on the search, the “non-summarized” results will show.  So even if you don’t want a particular field to show up in the actual results, if it’s useful,  let people see it in the drill down by including it in the results, just without being summarized.

More to Come

Tomorrow I’ll post a few more tips that I have in the back of my mind.  And, because a picture says a lot, I’ll probably record a video for this as well sometime soon as well.

If you have other tips and tricks, leave a comment!