BUILTIN.CURRENCY_CONVERT

This function converts a currency amount stored in a field to a target currency. The target currency is determined based on effective date of defined exchange rate. Currency Exchange Rates.

Parameters

Parameter	Required / Optional	Description	Acceptable Parameter Values
Original amount field	Required	The original amount field to convert.	-
Target currency	Optional	The currency to convert to. The default value is the default currency of the subsidiary.	Number Date
Date of the exchange rate	Optional	The effective date of exchange rate. The default value is today's date.	-

Syntax

            BUILTIN.CURRENCY_CONVERT(sales.amount) 

          

            BUILTIN.CURRENCY_CONVERT(sales.amount, 1) 

          

            BUILTIN.CURRENCY_CONVERT(sales.amount, 1, TO_DATE('2019-01-30', 'YYYY-MM-DD')) 

          

Related Topics

• SuiteQL Supported Built-in Functions
• SuiteQL
• Using SuiteQL
• BUILTIN.DF

General Notices