How to Create a Pop-Up Saved Search for Transaction Line Items in NetSuite

To implement a pop-up saved search on transaction lines, follow these steps:

1. Create the Saved Search:

   • Develop a Transaction Saved Search with all necessary filters and columns.
   • Set the appropriate Audience and ensure the search is public. Save the search.

2. Create Custom Item Internal ID Column:

   • Create a new custom "Transaction Column Field" of type "Integer Number".
   • Set "Applies To" to "Sales" and "Store Item".
   • Mark the field as "Hidden" and ensure its display type is hidden.
   • Configure this field to source the Internal ID of the Item. Save the column field.

3. Create Custom Pop-up Link Column:

   • Create another new custom "Transaction Column Field" of type "Inline HTML".
   • Set the required "Applies To" (e.g., "SALE ITEM").
   • Set the "Default Value" to the following HTML code, replacing with the actual internal ID of your saved search:

'< a class"dottedlink" href"javascript:void nlOpenWindow(%22&Transaction_ITEM'||{custcol_item_internal_id}||'%22,">https://system.netsuite.com/app/common/search/searchresults.nl?searchid<search_id>&Transaction_ITEM'||{custcol_item_internal_id}||'%22, null, %22widthu0, height 00, resizableyes, scrollbarsYes%22)">Purchase History < / a >'

1. Understand the Link Structure:

   The provided HTML link utilizes a legacy NetSuite JavaScript function to open a new window, passing the necessary parameters. It constructs a URL that calls the Saved Search's URL and appends the parameter &Transaction_ITEM'||{custcol_item_internal_id}||. This parameter corresponds to an "Item" type Available Filter in the saved search, passing the value from the custom Internal ID column created in step 2.