N/currency Module for Multi-Currency Management in NetSuite

The N/currency module allows you to work with exchange rates within your NetSuite account. This feature is essential for businesses that transact in multiple currencies, as it enables you to find the exchange rate between two currencies based on a specific date.

How to Enable Multiple Currencies

To utilize multiple currencies in your NetSuite account, ensure that the Multiple Currencies feature is activated. Follow these steps to enable it:

1. Navigate to Setup > Company > Enable Features.
2. On the Company subtab, check the Multiple Currencies box.
3. Click Save.

It's also advisable to ensure that your company's base currency is properly configured on the Currencies page found under Lists > Accounting > Currencies. This is crucial for accurate financial reporting.

Note: Make any changes to the base currency before proceeding with other configurations, as changing the base currency after records have been created can lead to complications.

N/currency Module Member

The N/currency module contains several members, the most notable of which is the currency.exchangeRate(options) method. This method is designed to return the exchange rate between two specific currencies.

Method Details

Example Usage

To effectively use the N/currency module, here's a sample script that demonstrates obtaining the exchange rate between the Canadian Dollar (CAD) and the U.S. Dollar (USD) on a specific date:

1/**
2 * @NApiVersion 2.x
3 */
4 
5require(['N/currency'], function(currency) {
6    function getUSDFromCAD() {
7        var canadianAmount = 100;
8        var rate = currency.exchangeRate({
9            source: 'CAD',
10            target: 'USD',
11            date: new Date('7/28/2015')
12        });
13 
14        var usdAmount = canadianAmount * rate;
15    }
16 
17    getUSDFromCAD();
18});

This script uses the require function to load the N/currency module and define a method to compute the equivalent USD amount based on the provided exchange rate.

Additional Notes

• Currency formatting is managed by the N/format module.
• The Multiple Currencies feature allows defining sales and purchase prices in multiple currencies on item records, enhancing your transaction capabilities.

By taking advantage of the N/currency module, businesses can ensure they operate efficiently in an increasingly global marketplace, allowing for accurate conversions and streamlined financial operations.

Source: This article is based on Oracle's official NetSuite documentation.