Multiple Currencies Examples
When you are working with custom lines in an account with multiple accounting books or multiple currencies, NetSuite automatically performs currency conversion in the following situations:
-
The transaction currency is different from the accounting book currency to which the GL impact posts. NetSuite performs a conversion to make standard lines appear in base currency. Custom lines do not require conversion, NetSuite creates the custom lines using the base currency.
For example, a transaction uses EURO for the items on the transaction, but the accounting book uses GBP. NetSuite converts from EURO to GBP when calculating the GL impact, depending on the exchange rate in NetSuite or the exchange rate specified on the transaction.
For more information, see Currency Management.
-
NetSuite maps custom lines from a primary accounting book to a secondary accounting book, and the two accounting books use different currencies.
For example, a primary accounting book uses USD and a secondary accounting book uses GBP, and you use setCreditAmount(credit) to set the amount of a custom line on a primary book with setBookSpecific(bookSpecific) set to false.
NetSuite converts the amount from USD to GBP when adding the custom line impact to the secondary book. For more information about the mapping of lines between primary and secondary accounting books by a Custom GL Lines plug-in implementation, see Custom GL Lines Plug-in Process Flow.
The currency to which NetSuite converts an amount depends on both the subsidiary and the accounting book currency. For example, a US company has two subsidiaries:
Subsidiary Name |
Secondary Book 1 Currency |
Secondary Book 2 Currency |
---|---|---|
United States |
USD |
GBP |
Canada |
CAD |
Euro |
Any GL impact posts to the secondary accounting books based on the currency for the subsidiary accounting book. The GL impact displays in the currency for the accounting book, and not the currency that appears on the transaction for the transaction line items.
Converting Currency in a Custom GL Lines Plug-in Implementation
In general, you do not need to perform manual conversion of currencies if you are using the amounts of standard lines posted to a transaction to calculate the values of custom lines. However, if you want to use hard-coded currency values or retrieve an amount to use in a custom line from a source other than a standard GL impact line, you need to manually convert the currency amounts.
To perform the conversion, complete the following steps:
-
Get the base currency. You can search for the base currency or get the base currency from the accounting book record. See Find the Base Currency and Base Currency from Accounting Book Record.
-
Perform the conversion. Get the transaction-specific conversion rate from the accounting book record or convert using the nlapiExchangeRate API. See Transaction-Specific Exchange Rates or Convert Currencies with SuiteScript.
Related Topics
- Custom GL Lines Plug-in Example Code
- Classifications
- Custom GL Lines Plug-in Guidelines and Best Practices
- Error Messages for Custom GL Lines Plug-in
- Custom Lines on Reports and in Searches
- Accessing the Custom GL Lines Audit Log
- Reviewing Custom GL Lines Plug-in Executions
- Deleting a Custom GL Lines Plug-in Implementation