This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Anyone have a formula for pulling account specific url for a sales order saved search and show the SO URL in a formula(text) field?

Why do you need the account specific URL instead of the generic ending?  The generic ending links work while logged into NS

I'd probably cheat and create a subsidiary field and load it there if I really needed it.

all about using what I know to quickly solve problems haha. I can't ever get that generic ending link thing to work reliably.

Hey <@U7XBU8Y3B> <@UER9Q3SGM> I guess it doesn't really matter how its created just looking to add a URL link to the SO when running a SO specific search

Right now I'm having issues with &gt; &lt;a href="https://*.<http://app.netsuite.com/app/accounting/transactions/salesord.nl?id='%7C%7C{internalid}%7C%7C'|app.netsuite.com/app/accounting/transactions/salesord.nl?id='||{internalid}||'>

Also - https://*.<http://app.netsuite.com/app/accounting/transactions/salesord.nl?id='%7C%7C{internalid}%7C%7C|app.netsuite.com/app/accounting/transactions/salesord.nl?id='||{internalid}||>

wouldn't you just use `//accounting/transactions/salesord.nl?id=||{internalid}`

<@UER9Q3SGM> just tried it but isn't pulling it yet. thanks for sending it over

any particular reason you cant use a column like transaction name which automatically creates links in the ui?

<@U5TF1GQ20> I'm not too sure what you mean ha. I think I just got the text formula working though. I'm going to take this formula and use it on a custom field and use it for approvals

Hey <@UER9Q3SGM> <@U7XBU8Y3B> <@U5TF1GQ20> I used: '&lt;a href=https://&lt;insert account info here&gt;.<http://app.netsuite.com/app/accounting/transactions/salesord.nl?id='%7C%7C{internalid}%7C%7C'|app.netsuite.com/app/accounting/transactions/salesord.nl?id='||{internalid}||'>&gt;https://&lt;insert account info here&gt;.<http://app.netsuite.com/app/accounting/transactions/salesord.nl?id='%7C%7C{internalid}%7C%7C'|app.netsuite.com/app/accounting/transactions/salesord.nl?id='||{internalid}||'>&lt;/a&gt;'

This gave me the right link and kept the url. I'm going to use this formula for a custom field on the sales order to send out for approvals