How to Create Sublist in NetSuite

sublist in netsuite

Table of Contents

Stay Updated

Subscribe to get the latest news, industry trends, blog posts, and updates...

NetSuite provides us an ability to create sublist of different types. Its also gives us a way to show a saved search result as sublist view. In this article I’ll show you how to display the result of saved search of type Custom Record as sublist in Customer record.

Here I’ll create a custom record type, assuming that it maintains custom history of customer’s field change data using user event.

CTA - NetSuite Integration Connector Banner

Custom Record Type:

  1. Enter the name for Name. E.g. Customer History
  2. Uncheck Include Name Field field
  3. Saved
  4. Add fields:
    • Customer
    • Record Type
    • Field Id
    • Old Value
    • New Value
  5. Set permissions according to your needs.

I assume that history records has already been created.

Now I’ll create a saved search.

CTA - NetSuite SuiteCommerce Migration Banner

Create a Saved Search:

  1. Navigate to Reports > New Saved Search
  2. Click on Customer History record as created above.
  3. Enter the name for Search Title. E.g. Customer History
  4. Set Public to True
  5. Set Available as Sublist View to True
  6. In Results tab add fields as needed
  7. In Available Filters tab, select Customer field in first line. It is a field on which the records will be displayed. (Customer in our case)
  8. Save the search

Finally to show saved search result as sublist:

CTA - NetSuite eBay Motors Connector

Create a Sublist in NetSuite

  1. Navigate to Customization > Forms > Sublists
  2. Select the tab corresponding to the type of record where the search will show as a sublist. For this example Customer.
  3. Click the Entity tab.
  4. Select the name of the search created above in Search column. E.g. Customer History
  5. Enter a name for the Label column. E.g. Customer History Sublist
  6. Select the name of the tab where you want to display this sublist under the Tab column. E.g. General
  7. Put a checkmark for the Customer column.
  8. Click Save.

If you have a NetSuite Customization requirement you would like to discuss, or would like to know more about our NetSuite Customization services, please get in touch with us

Related resources you might be interested in

Do you have similar NetSuite implementation, integrations or customization needs?

Folio3 Your Top Choice:

Let's discuss your NetSuite needs

Hello, How can we help you?