Hello there fellow Netsuiet experts! I have a question! How do i get the ISO code for the currency a customer included in a saved search! I have tried joining it on currency without luck.

Did you try Analytics workbook for this? Apparently it has better joining options than SS.

I need the "Symbol" AKA iso code to show up on a search, then be used in an API call JSON string.

ISO = International Standard Organization, therefore the code is universal, just go to ISO site and download the currency list. This quite straight forward, you dont need a saved search to get this.

I dont think you quite understand the question. I need to get the iso value out in a search to put it over in an api call in json format.

Ah Aha!! You cannot create a currency search from the usual list, but all the data in NS is searchable. Hers is my hack below: go to list >accounting>currency> New - just attempt to create a new currency (dont create any) -you should have a search option on the top right corner of the currency form - Just create your search (make sure to check the advance search)