Number Formats
Set the Number Format and Negative Number Format preferences to determine how numbers display on the screen for transaction forms, entity forms, and search results. These formats also apply to the list pages associated with these forms and fields that can be edited inline.
You can set the number format preferences at the company, subsidiary, and user levels. This enables users to work in NetSuite with familiar number formats customary for their region and prevents errors that result from incorrectly interpreting numbers on the screen.
The Number Format preference provides the following format options for thousands separators and decimal places:
-
thousands separator: comma, period, space, reverse comma
-
decimal places: comma, period
Users do not have to key in numbers with separators. Numbers are formatted according to the selected preferences upon tabbing out of a field.
The Negative Number Format preference provides two options to display negative numbers:
-
minus sign: -100
-
parentheses: (100)
You can set the Number Format and Negative Number Format preferences at the following levels. The default formats are 1,000,000.00 and -100.
-
Company: Go to Setup > Company > Preferences > General Preferences (Administrator). For instructions, see Setting General Account Preferences.
-
Subsidiary: Go to Setup > Company > Classifications > Subsidiaries > New (Administrator). Select a subsidiary and edit the preferences. For instructions, see Editing Subsidiary Records.
-
User: Go to Home > Set Preferences. Setting the preferences at the user level affects all roles associated with that user. For instructions, see General Personal Preferences.
Key Points for Number Format Preferences
-
Number format preferences do not apply to exports, SOAP web services, SuiteScript, and CSV imports.
-
Currency format settings apply to amounts on reports and printed transactions.
-
Values with a currency symbol, such as €123,45 or $123.45, render according to the currency format, not the number format preference.
-
On the screen, foreign currency amounts render in the format for the currency. Base currency amounts displayed in columns on transactions forms and subtabs follow the number format preferences.
-
The user preference setting for number format overrides the subsidiary and company format settings.
-
Number format preferences do not apply to custom fields created before 2012.1, unless you explicitly enable the Apply Formatting preference. This preference also enables you to prevent custom fields created after 2012.1 from using number formatting. For details, see Setting Display Options for Custom Fields.