Currency

Internal ID: currency

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
currencyformatsample text false Format Sample false
currencyprecision select false Currency Precision false Displays the precision of the currency, which designates the number of digits to the right of the decimal point used in currency transactions. Precision can be zero or two. The level of decimal precision indicated is used for inventory costing calculations to maintains consistency between inventory costing and reporting. Values in report results are rounded to the base currency precision. This rounding applies to currency values and non-currency values, including formula column values. To change this read-only field to a dropdown list through which you can change the precision from zero or two, contact NetSuite Technical Support.
displaysymbol text false Symbol false Enter the currency symbol and text to use for this currency. Include spaces if you want to separate the symbol from the currency value. For example, $ USD or $CAD.
exchangerate currency2 false Default Exchange Rate ( to root subsidiary currency ) true Enter an exchange rate for this currency against the base currency of this company, or if you use OneWorld, for this currency against the base currency of the root parent subsidiary. The exchange rate is equal to the base currency amount divided by the foreign currency amount. For example, if your company is located in Canada (base currency) and you are defining the U.S. dollar (foreign currency), and the current exchange rate is 1.02 Canadian dollars to 1.00 U.S. dollar, the Default Exchange Rate for the U.S. dollar is 1.02/1.00, or 1.02. This rate is the basis for rates in the Currency Exchange Rates table that are used in foreign currency transactions. If you use OneWorld, this rate also is the basis for rates in the Consolidated Exchange Rates table that are used in consolidated financials.For more information, see the help topic Currency Exchange Rates.
externalid text false ExternalId false
includeinfxrateupdates checkbox false Automatic Update false Check this box to update currency exchange rates daily.
isbasecurrency checkbox false Is Base Currency false Indicates that this currency is the company's base currency or in OneWorld accounts, the base currency for a subsidiary. Note: After you have entered transactions in foreign currencies, you cannot change a base currency.
isinactive checkbox false Inactive false Check this box to make the currency record is inactive, or clear it to make the record active. You cannot make a currency inactive if any open transactions exist in that currency.
name text false Name true Enter a unique name for the currency. Because many countries use the same name for their currencies, you should use a combined name that includes the country name or abbreviation as well as the name of the currency. For example, pesos are the currency in the Philippines, Uruguay, and Mexico. In the Name field, you might enter “Mexican peso.” This name appears in the Currency field on records and transactions.
overridecurrencyformat checkbox false Override Currency Format false Check this box to customize the currency format.
symbol text false ISO Code true Enter the three-letter International Standards Organization (ISO) code for this currency. For example, you would use PHP for Philippines pesos, UYU for Uruguayan pesos, and MXN for Mexican pesos.
symbolplacement select false Symbol Placement false Select whether the symbol appears before or after the number. Note: The symbol position you select in the Symbol Placement field appears only on transaction records. It does not appear on reports.

Search Filters

Internal ID Type Label
exchangerate float Exchange Rate
externalid select External ID
externalidstring text External ID (Text)
formuladate date Formula (Date)
formulanumeric float Formula (Numeric)
formulatext text Formula (Text)
internalid select Internal ID
internalidnumber integer Internal ID (Number)
isinactive checkbox Inactive
name text Name
symbol text Symbol

Search Columns

Internal ID Type Label
exchangerate float Exchange Rate
externalid select External ID
formulacurrency currency Formula (Currency)
formuladate date Formula (Date)
formuladatetime datetime Formula (Date/Time)
formulanumeric float Formula (Numeric)
formulapercent percent Formula (Percent)
formulatext text Formula (Text)
internalid select Internal ID
isinactive checkbox Inactive
name text Name
symbol text Symbol