NetSuite Create A Custom Field Using A Saved Search

Netsuite Create a custom field using a saved search

Sometimes, we are required to have some complex or calculated data in NetSuite under a custom field for any Record Type which can’t be achieved simply by using the formula field and sourcing. In this article, we are about see that how can we create a Saved Search and link it to a Custom Item Field. Let’s begin it with a simple use case or problem.



Assuming, we are required to show stocks (item available) of two different countries in two different custom fields for each inventory item e.g Show United States and Canada available items quantity in two different fields. Currently, NetSuite doesn’t have any built-in method to do this. To resolve this issue, we adhere to two straightforward procedures.


  • Create a Saved Search
  • Create a Custom Field for inventory items using Saved Search


Create a Saved Search:


  1. To initiate the process, navigate to the Reports section and proceed to select New Search. Alternatively, you can type “New Saved Search” in the main search bar and click on “Page: New Saved Search.”
  2. Select Item (From “Record Types” list)
  3. From Saved Search Form:
    1. Give Search an appropriate title (Example: Available items in US Search)
    2. Check “Public”
    3. Add a filter under Criteria -> Standard
      1. Filter: Inventory Location: Country
      2. Description: Is United States
    4. Add a result column under Results -> Column
      1. Field: Location Available
      2. Summary Type: Sum
    5. Select filter under Available Filters
      1. Filter: Internal ID (This will play an important role to link and filter search result for a specific item)
  4. Click on Save & Run.


New Saved Search For Item


Access the Form Criteria tab for the Saved Item Search


View the results of the Saved Item Search in the Form Results tab


Saved Item Search Form Available Filters Tab


Saved Search Result For Items

This kind of search can be created for any Record Type in NetSuite. At this stage, we have successfully created a saved search and it is now essential to establish a link with a custom field.



Create a custom field for item using Saved Search:


  1. Go to Customization -> Lists, Records & Fields -> Item Fields -> New
    1. From Custom Item Field Form:
    2. Give Field a label (Example: Available items in US)
    3. Opt for Free-Form Text (or Integer, depending on the context) as the designated Type
    4. Un-check “Store Value” checkbox
    5. Under Applies To (Tab)
      1. Check Inventory Item
    6. Under Validation & Defaulting:
      1. Select newly created search under “Search” dropdown (Available items in US Search)
  2. Save & Apply to Forms.


NetSuite Create a Custom Item Field Form


NetSuite Create a Custom Item Field Form Validation and Sourcing Tab


Saved Search result as per our defined case.

That’s it. Go to any inventory item under Custom Tab and see that field (Available items in US).

This is one of the very useful features in NetSuite Development and Administration. There is a lot of possibility for utilizing this feature like showing item categorization under sales order, customer orders and estimate counts and many more.

PS: You should have some items in your stock to view the result properly.


Do you want to Integrate NetSuite into your project?

Hire us for a Wide Range of Netsuite Development Services