Budget Exchange Rate
A budget exchange rate record exposes a budget exchange rate to REST web services.
The Budget Exchange Rates table is available at Lists > Accounting > Budget Exchange Rates.
The Budget Exchange Rates table is similar to the Consolidated Exchange Rates table. In OneWorld, NetSuite uses the Consolidated Exchange Rates table to initially populate the Budget Exchange Rates table. Then, you can update and maintain the Budget Exchange Rates table as necessary. This table shows the exchange rates for each subsidiary's base currency in relation to the currencies used by its parent subsidiaries, for each period.
Exchange rates in this table are either direct or indirect (derived). Direct rates are rates set between a child and parent subsidiary. Direct rates are set by a user and can be edited. Indirect rates are rates set between a grandchild and grandparent subsidiary. Indirect rates are always calculated by the system and can't be edited. Budget exchange rates include three rate types for each period, subsidiary, and accounting book: Average, Current, and Historical.
This record:
-
isn't a subrecord
-
contains no subrecords
For more information about the budget exchange rate record and working with it in the UI, see Budget Exchange Rates.
For information about using the REST API Browser, see The REST API Browser.
Record ID
The record ID for a budget exchange rate REST record is budgetexchangerate.
Prerequisites
The budget exchange rate record is available only when the following features are enabled:
-
Multiple Currencies. For more information, see Enabling the Multiple Currencies Feature.
-
Multiple Budgets. For more information, see Multiple Budgets and Budget Categories.
Your user role must have the Currency permission with Full permission level to work with budget exchange rates.
Usage Notes
The budget exchange rate record can only be edited through REST. As in the UI, only the following three fields are editable:
-
Average Exchange Rate
-
Current Exchange Rate
-
Historical Exchange Rate
Sample Code
The following code sample shows how to update the Average Exchange Rate, Current Exchange Rate, and Historical Exchange Rate fields through REST web services.
PATCH {{REST_SERVICES}}/record/v1/budgetexchangerate/{id}
{
'averageRate': 1.4,
'currentRate': 1.5,
'historicalRate': 1.42
}