getBudgetExchangeRate
On the Budget Exchange Rates table, you can maintain exchange rates between the root-parent and child subsidiaries for use in the budgeting process. In SOAP web services, you can use the getBudgetExchangeRate operation to get and filter all data related to this table.
SOAP Request
The following request shows the usage of the getBudgetExchangeRate operation.
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<getBudgetExchangeRate xmlns="urn:messages_2025_1.platform.webservices.netsuite.com">
<budgetExchangeRateFilter>
<ns1:period internalId="3" xmlns:ns1="urn:core_2025_1.platform.webservices.netsuite.com"/>
<ns2:fromSubsidiary internalId="4" xmlns:ns2="urn:core_2025_1.platform.webservices.
netsuite.com"/>
</budgetExchangeRateFilter>
</getBudgetExchangeRate>
</soapenv:Body>
</soapenv:Envelope>
SOAP Response
The following response shows the result of the operation.
<?xml version="1.0" encoding="utf-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<getBudgetExchangeRateResponse xmlns="urn:messages_2025_1.platform.webservices.netsuite.com">
<platformCore:getBudgetExchangeRateResult
xmlns:platformCore="urn:core_2025_1.platform.webservices.netsuite.com">
<platformCore:status isSuccess="true"/>
<platformCore:budgetExchangeRateList>
<platformCore:budgetExchangeRate>
<platformCore:period internalId="3"/>
<platformCore:fromSubsidiary internalId="4"/>
<platformCore:toSubsidiary internalId="1"/>
<platformCore:currentRate>1.9586</platformCore:currentRate>
<platformCore:averageRate>1.9586</platformCore:averageRate>
<platformCore:historicalRate>1.9586</platformCore:historicalRate>
</platformCore:budgetExchangeRate>
</platformCore:budgetExchangeRateList>
</platformCore:getBudgetExchangeRateResult>
</getBudgetExchangeRateResponse>
</soapenv:Body>
</soapenv:Envelope>
In REST web services, you can work with budget exchange rates by directly interacting with the budget exchange rate record.
The budget exchange rate record is available in REST 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.
REST Request
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
}