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.

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. So, here are 2 simple steps we follow to fix this problem.

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

Create a Saved Search:

  1. Go to Reports -> New Search (Or write in the main search “New Saved Search” then 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
Saved Item Search Form Criteria Tab
Saved Item Search 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. So far, we have made a saved search and now it’s time to link this 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. Choose Free-Form Text (or Integer in this case) as 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.

CEO and Technical Lead at Intelvue

Contact Us

Pakistan

Address
G-7, Amber Castle Building, Shahrah-e-Faisal, Karachi 75300, Pakistan

Upgrade your store from Magento 1 to Magento 2

Avoid performance issues with upgrade assistance from the experts

Schedule a free site assesment by our expert

FoodFila
Fikvip
Natuzzi
Sport Mania
ISP Supplies