Search without consolidated exchange rate via SuiteScript 2.0

Question

How do I create a saved search via SuiteScript 2.0 with consolidated exchange rate set to none? It's easy to do via the Saved Search UI (on results tab), however, I can't find a way to do this via SuiteScript.

score 2 · Answer 1 · answered Sep 22 '17 at 10:29

2

Use the NetSuite Saved Search Export Chrome Extension:

https://chrome.google.com/webstore/detail/netsuite-search-export/gglbgdfbkaelbjpjkiepdmfaihdokglp?utm_source=chrome-app-launcher-info-dialog

Since you already have the saved search, this is the easiest way to get the SuiteScript equivalent.

answered Sep 22 '17 at 10:29

Rusty Shackles

2,802
10
11

2

While this is a very useful tool (thanks!), the generated code does not include a way to turn off consolidated exchange rates. – angrycrab Sep 22 '17 at 15:03

score 1 · Answer 2 · answered Mar 16 '21 at 22:10

1

NetSuite finally included the settings attribute for search on SuiteScript 2.0

you just need to add this:

columns:[],
settings:[
    search.createSetting({
        name: "consolidationtype",
        value: "NONE"
    })
]

If you want, you can check the other settings available, at the API Reference Guide, section: search.createSetting(options)

https://docs.oracle.com/cloud/latest/netsuitecs_gs/NSAPI/NSAPI.pdf

answered Mar 16 '21 at 22:10

Alessandro Aguiar

41
5

and this is not available in 1.0? – 4N335 Jun 06 '22 at 07:06

score 0 · Answer 3 · answered Sep 26 '17 at 10:47

Here's a solution I found in case any one else is looking: You can create a saved search via the UI with the Consolidated Exchange Rate set to none and leave columns and filters empty. Then, all you need to do is load that saved search via script and specify the columns and filters. If you don't care about changing the columns or filters via script, you could also define them in the UI.

Search without consolidated exchange rate via SuiteScript 2.0

3 Answers3