This article is relevant to you if you are running your business on Oracle NetSuite and would like to add a custom hyperlink on a saved search column where NetSuite doesn't offer one.
One of our clients had a requirement to bill Sales Orders a day after creation of an Item Fulfillment.
This way if a customer decided to change an order on the same day that it is to be shipped, there wouldn't be too much of a disruption.
The saved search we decided to configure was based on the Item Fulfillment record.
A link form the result set back the Sales Order was necessary.
The "Created From" field was the most logical field on which to add the link.
Unfortunately that field does not natively appear as a link back to the underlying transaction.
We overcame and accomplished creating the hyperlink by adding a "Formula HTML" field with some special code noted below.
CASE WHEN
{createdfrom.number} IS NULL
THEN ' '
ELSE '<a href=https://xxxxxx.app.netsuite.com/app/accounting/transactions/salesord.nl?id='||{createdfrom.internalid}||' target="_blank">'||{createdfrom.number}||'</a>'
END
We typically try to eliminate the "https://xxxxxx.app.netsuite.com/" part of when linking around the same account.
In that case we simply start with "/app/...".
This way the links still work in SandBox, Release Preview or Development accounts as well as Production.
Here's what we've been up to recently.
This article is relevant to you if you are running your business on Oracle NetSuite and would like to add an isolated custom note on a transaction line. This article demonstrates a simple end to end architecture to customize and extend the capabilities of NetSuite.
This article will be relevant for you if your company is using NetSuite ERP, uses standard inventory items and a new business requirement arises where you now need the functionality of Serialized or Matrix for an existing item.
From us to your inbox.
