19 February, 2019

Records Browser – NetSuite Saved Search Tips N’ Tricks (Part 1)

Introduction

If you are a NetSuite user, there is no chance that you haven’t encountered NetSuite Saved Searches and tried to manipulate them. This powerful tool has many neat capabilities and it can be used in ways that are not always transparent. In this blog I will touch on one tool and two tricks that will enhance your knowledge of Saved Searches. Note, this article is meant for intermediate to advanced users of NetSuite

Records Browser

Infographics show the Records Browser - NetSuite Saved Searches

I frequently refer to the Records Browser as ‘NetSuite’s Bible’. The Records Browser is neither holy nor do I intend on turning this blog into a religious discussion. That being said, this tool is an ‘Alpha and Omega’ when it comes to understanding of NetSuite’s data objects, records and their relationships with each other. It’s immensely helpful when you are building Saved Search formulas or when you are simply struggling to find a field in NetSuite’s Saved Search interface.

Records Browser Link

Firstly, notice the letter index at the top. All records are indexed by their name for easy lookup. Let’s say you want to inspect a Sales Order transaction record. Please click on a letter ‘S’ within the index section, next click on the Sales Order tab to the left.


Infographics show the Sales Order tab
  1. Every page in the Records Browser will show the following:

Optimize your Saved Searches with NetSuite

Ready to maximize the power of your saved searches in NetSuite? Partner with AlphaBOLD to optimize your NetSuite setup and achieve unparalleled efficiency.

Request a Demo

a) All the Header / Body Fields:

Infographics show the All the header - BODY FIELDS

Here, you will find the ‘Label’ column very useful as you can easily look-up a field on this page which isn’t the case when it comes to NetSuite UI’s drop-downs.

Infographics show the NetSuite UI’s drop-downs

Also, when you are building SQL formulas by using the formula fields it is useful to know the internal id’s of NetSuite fields. Records Browser exposes these in the first column (see screenshot above).

b) Sublist fields:

If you continue scrolling down, Records Browser will display all the available sublists and their column fields.

Infographics show the sublists fields
Infographics show the User Guide for NetSuite Solutions

NetSuite Supply Allocation Guide

Navigate supply allocation efficiently with our NetSuite guide. Streamline operations effortlessly.

Download Guide

c) Joins, Filters and Columns:

Now comes the interesting part. Previous two points (a & b) deal with fields that are exposed and supported on the record. Not all of these fields can be selected in Saved Search’s criteria and results tabs. Before I get to this, let me explain three important elements of NetSuite’s Saved Searches.

Infographics show the Joins Filters and Columns

Joins:

Let us take a second to explain what joins are. The following is a boring definition from Wikipedia. Join is an operation that ‘combines columns from one or more tables in a relational database‘.

Infographics show the joins

In translation, when I am looking up a transaction via a Saved Search, an example of ‘join’ would be a field from the Customer record that I would want to expose as a column on my Saved Search results screen.

Joins:

(records that are linked to the object that you are looking up through the Saved Search interface) are always at the bottom of the Saved Search’s drop-downs and they can be recognized by a 3-dotted suffix (‘…’).

Infographics show the Saved Search interface

Now that we understand what ‘joins’ are, let us take a look where we can find them in the ‘Records Browser’. In our previous example, Sales Order is just a type of transaction in NetSuite. Consequently, by scrolling all the way to the bottom of this screen

https://system.na1.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2018_1/script/record/salesorder.html

… and by clicking on (Transaction

Infographics show the Sales Order search data

… we can see all the records that are linked to transactions (also called joins).

Infographics show the linked to transactions - saved searches

Filters (Saved Search Criteria):

As mentioned above, not all fields can be looked up in NetSuite or can they be used as criteria. The ones that are available are listed on this page.

Infographics show the Saved Search Criteria

Remember, ‘filters’ is the criteria tab of your Saved Search interface.

Read More: Item Tricks – NetSuite Saved Search Tips N’ Tricks (Part 2)

Infographics show the Saved Search interface

Columns (Saved Search Results):

Infographics show the SAVED SEARCH RESULTS

On the same Records Browser page, keep on scrolling.

Infographics show the Results tab - NetSuite saved searches.

These are the fields that are available under the Results tab of NetSuite’s Saved Search interface.

Streamline your Processes with NetSuite

Ready to streamline your workflows and boost productivity with NetSuite? Partner with AlphaBOLD to implement best practices and unlock the full potential of NetSuite for your business

Request a Demo

Conclusion

To conclude, mastering Records Browser and learning how to navigate it will help you build amazing Saved Searches. Stay tuned for the second part of this blog where I will walk you through two Saved Search tricks that will demonstrate how powerful Saved Searches can be.

If you have any question or queries, do not hesitate to reach out to us

Explore Recent Blog Posts

270x330

Related Posts

Receive Updates on Youtube
Copyright © 2024 AlphaBOLD | NetSuite Solution Provider | All Rights Reserved