Suppose you’ve created a search on Item Receipts, but you’d like to open the associated Purchase Order. This can be done by adding a Formula (Text) field to the results section of your results of the saved search.
Firstt, enter an HTML link surrounded by single-quotes as shown below.
'<a href="LinkGoesHere">Link Text Here</a>'
Then, in a separate tab, open the record type you want to link to; Now copy the URL to that record as shown.
eg: https://COMPID.app.netsuite.com/app/accounting/transactions/purchord.nl?id=4262238&whence=
Note that COMPID will be your NetSuite company ID.
Next, delete all of the text after “?id=“ to get a link such as: https://COMPID.app.netsuite.com/app/accounting/transactions/purchord.nl?id=
This link is what we’ll use in our formula.
In order to get the ID of each Purchase Order associated to the Item Receipt, we can use the Created From fields option to get the Internal ID value. This looks like {createdfrom.id}. So we need to do is append this value into our link from above.
‘<a href=“https://COMPID.app.netsuite.com/app/accounting/transactions/purchord.nl?id=’ || {createdfrom.id} || ‘”>’ || {createdfrom} || ‘</a>’
