Consolidated Exchange Rate

A consolidated exchange rate record exposes a consolidated exchange rate to REST web services.

Consolidated exchange rate records ensure that currency amounts translate properly from child to parent subsidiaries for consolidated reports. NetSuite creates initial consolidated exchange rates when associated subsidiaries and accounting periods are created.

To access this record, go to Lists > Accounting > Consolidated Exchange Rates.

For more information about consolidated exchange rates in NetSuite, see Consolidated Exchange Rates.

The REST API Browser includes information about the field names and field types of the consolidated exchange rate record and about the HTTP methods, request parameters, and operations available to this record. For details, see the REST API Browser’s consolidatedExchangeRate reference page.

For information about using the REST API Browser, see The REST API Browser.

Record ID

The record ID for a consolidated exchange rate REST record is ConsolidatedExchangeRate.

Prerequisites

You must enable the Multiple Currencies feature before you can use this record through REST web services.

Elements with Different Functionality

The following fields have different functionality through REST web services:

  • accountingBook (Read only)

  • fromCurrency (Read only)

  • fromSubsidiary (Read only)

  • isDerived (Read only)

  • isEliminationSubsidiary (Read only)

  • isPeriodClosed (Read only)

  • periodStartDate (Read only)

  • postingPeriod (Read only)

  • toCurrency (Read only)

  • toSubsidiary (Read only)

Usage Notes

The Full Multi-Book Accounting feature must be enabled if you want to view or edit the following field:

  • accountingBook

Code Sample

This sample shows how to update the historical exchange rate using a PATCH request:

            PATCH {{REST_SERVICES}}/record/v1/consolidatedExchangeRate/10
{
"historicalRate": 0.8655
} 

          

Related Topics

REST Web Services Supported Records
SuiteTalk REST Web Services Overview and Setup
Working with Records
NetSuite Record Structure
The REST API Browser

General Notices