https://netsuiteprofessionals.com logo
#suitescript
Title
# suitescript
f

fsandi

04/21/2022, 5:08 PM
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
t

texmc

04/21/2022, 5:11 PM
maybe an https to suitelet in a different role?
p

Paul Vana

04/22/2022, 6:57 PM
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.
Copy code
// 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
3 Views