When multicurrency functionality is not enabled, h...
# suiteql
s
When multicurrency functionality is not enabled, how can I get the base ISO currency code (e.g. USD) via SuiteQL?
m
I spent some time investigating this last year, but could never find the answer. IIRC, the currency table didn't exist when the feature was disabled 😞
m
You could lookup the currency from the parent subsidiary?
m
There are a couple weird edge cases: • Subsidiaries exist, but not multi-currency • No subsidiaries exist (implying not multi-currency) When I ran into this last year, there was not an easy way to get the base currency used on the NetSuite account using suiteql. Read from the currency table were blocked unless the multi-currency feature was enabled. In the first case, the subsidiary had a currency field but it was just an integer and there was no way to JOIN against the currency table sadly
Not sure if NS has changed anything since. Unfortunately I don't have a NS account to test this out on anymore