Is it possible to create a saved search that pulls...
# suiteanalytics
j
Is it possible to create a saved search that pulls a list of Currencies similar to Lists > Accounting > Currencies page? I would have assumed I just run a saved search on the currency/currencies record, but that doesn't seem to be in the list, so I have once I again learned the lesson of what happens when you assume...
j
What’s the use case? You can export off the Lists->Accounting->Currencies page
BTW It’s not listed as a Search Type but /app/common/search/search.nl?searchtype=Currency&rectype=-1&cu=T&e=F pops you into creating a Currency search
tho it seems to exclude default currency
j
Use case is that one of the devs wants to programmatically pull the list of currencies in NetSuite (we're expecting to add a few over the next several years) to do some work with some data in other systems for something. Super specific, I know, but that's what I know at this point.
j
SELECT * FROM currency
in SuiteQL would do the trick.
☝️ 1
j
not sure we've done SuiteQL stuff yet, but will explore that
j
it’s awesome, I use it all the time now.