Sharon Brown
03/27/2025, 8:32 PMCeligo AI
03/27/2025, 8:33 PMAI generated answer (using internal Slack threads):To create a hyperlink to a transaction in NetSuite, you can use a custom field with a formula that generates the hyperlink. The formula will use the internal ID of the transaction to generate a unique URL for each transaction. Here is an example of how you can do this: 1. Create a custom field of type "Free-Form Text" or "Hyperlink". 2. In the "Formula" field, enter the following formula:
html
'<a href="https://[YOURACCOUNTNUMBER].app.netsuite.com/app/accounting/transactions/purchord.nl?id=' || {internalid} || '">Link Text</a>'
Replace [YOURACCOUNTNUMBER]
with your actual NetSuite account number and Link Text
with the text you want to display for the hyperlink.
This will create a hyperlink that opens the transaction in a new window. If you want the link to open in the same window, you can modify the formula like this:
html
'<a href="https://[YOURACCOUNTNUMBER].app.netsuite.com/app/accounting/transactions/purchord.nl?id=' || {internalid} || '" target="_self">Link Text</a>'
If you want to create a hyperlink in a saved search, you can use a similar approach. However, you will need to use a "Formula (HTML)" field instead of a "Formula (Text)" field. Here is an example:
html
'<a href="/app/accounting/transactions/transaction.nl?id=' || {internalid} || '">View</a>'
This will create a hyperlink that works for all transaction types in the saved search. The URL is relative, so it will work in any environment (production, sandbox, etc.).
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
03/27/2025, 8:33 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.857221901
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.844260514
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.83421433
Celigo AI
03/27/2025, 8:33 PM