Home » Deeper in to NetSuite » How to Create Sublist in NetSuite

How to Create Sublist in NetSuite

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

Get In Touch With Our Experts


    Get In Touch With Our Experts

      I have read and agree to the Privacy Policy of Folio3
      I agree to be contacted by Phone or Email by Folio3

      Get in touch with the

      Award-Winning

      End-to-end NetSuite Servicing Agency

      Tell us how may we assist you!