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

I'm not crazy, you didn't used to be able to pull the ISO code out of the Currency join on a Transactions saved search right? Well if anyone else was continually annoyed by that, it's there now.

still can't get it on a currency rates search :netsuite:

because why would you?! did you know that you can get to all the FX info you need (including ISO codes) by using an Analytics Workbook? For some reason, it's not exposed as a dataset option in the UI, but you can directly navigate to it by using this URL and it saves fine>

<https://[your_account].app.netsuite.com/app/common/report/dataset.nl?recordType=CurrencyRate>

When Analytics Workbooks first released, it was exposed in the UI. Then they blocked it either accidentally or on purpose. No idea why. Credit to I believe <@U29QCJQF3> for showing me this first.

Yes luckily enough we saved a currency rate dataset before the purge, so we can just build off that. Very odd though - I would imagine it's related to Netsuite's market data licence