Hi everyone, do you know how to set which consolidated exchange rates to use (as we are doing in a Netsuite saved search) when querying Netsuite using SuiteQL? I'm replacing a saved search that today it's exported as a CSV in one external system with a SuiteQL request. Thank you in advance
s
Shai Coleman
11/16/2023, 4:54 PM
I think it needs to be joined depending on the rate type from
account.generalrate
Shai Coleman
11/16/2023, 4:55 PM
There's also the
BUILTIN.CONSOLIDATE
function
a
Andrea Rivetti
11/17/2023, 1:53 PM
Oh, I think that then this is the case @Shai Coleman