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

My base issue is, that this is a multicurrency/multisubsidiary set up, and because Map reduce always runs as administrator, all the saved searchs return the transaction amounts on the base currency of the administrator role, but we need the saved searches to return the amounts on the currency of other roles

maybe an https to suitelet in a different role?

I had the same issue before but with dates.  Our compay is AUS so it is dd/mm/yyyy and I am in the US so I needed mm/dd/yyyy.  I used the below code to change it in the scheduled script I was running.

```// OVERRIDE THE SYSTREM PREFERENCE ON THE DATE SINCE IT IS RUNNING AS THE ADMIN
var configRecObj = config.load({type: config.Type.COMPANY_PREFERENCES});
configRecObj.setValue({
    fieldId: 'DATEFORMAT',
    value: 'MM/DD/YYYY'
});
configRecObj.save();```


I think the fieldId should be   basecurrency