how to have an hyper link to a transaction in NetS...
# ask-stanley-ai
s
how to have an hyper link to a transaction in NetSuite
c
AI 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:
Copy code
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:
Copy code
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:
Copy code
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. ******
Slack 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
Please provide your feedback on this answer.