Scenario: A formula can be used to add hyperlink to your Saved Transaction Searches which directs users to the Item record.
Solution:
Go to Reports > Saved Searches > All Saved Searches > New.
Select Transaction.
Click the Results tab.
Add a Formula (Text) to the Search columns.
Enter this as the formula:
‘<a href="https://.app.netsuite.com/app/common/item/item.nl?id=’ || {item.internalid} || ‘ target=_blank>’||{item}||’‘
Note: Replace with the actual account ID of the account that is being worked on.
{item.internalid} defines the item internal id that matches.
{item} is to display the respective item name in saved serach
Enter a Search Title.
Click Save and Run.