Retrieve consolidated exchange rates from NetSuite for multi-subsidiary reporting

Steps

1. Ensure NetSuite OneWorld and Multiple Currencies are enabled; confirm that consolidated exchange rates are configured under Lists > Accounting > Consolidated Exchange Rates for each subsidiary-parent pair and accounting period.
2. Query the ConsolidatedExchangeRate table via SuiteQL (POST /services/rest/query/v1/suiteql): SELECT period, subsidiary, currency, currentrate, averagerate, historicalrate WHERE subsidiary IN (...) AND period = 'your_period_id'.
3. Join the result to the AccountingPeriod table to filter by period name or date range, and to the Subsidiary table to resolve subsidiary names, producing a rate matrix keyed by (period, subsidiary, currency).
4. Alternatively, query the CurrencyRate table for transaction-level spot rates when you need the rate applied to a specific transaction rather than the consolidated average or current rate.
5. Use the CURRENCY_CONVERT built-in SuiteQL function to translate amounts within a query: CURRENCY_CONVERT(amount, fromCurrencyId, toCurrencyId, transactionDate) to avoid pulling raw amounts and converting externally.
6. Export the rate matrix to your consolidation model or data warehouse on a nightly schedule; compare against your external rate provider's rates to detect data entry errors or outdated rates before running consolidation.