Support Note KB0397946
Email
Decimal separator in money fields shows as comma rather than point or vice versa
Issue

For a particular user, the decimal separator in money fields show as a comma rather than a point or the other way around. For example, for an amount of one hundred dollars and ninety nine cents, the system would show 100,99 USD. For an amount of ten thousand dollars and ninety nine cents, the system would show 10.000,99 USD. When the expected notation in this scenario is 10,000.99 USD, this can cause issues when filling a money field in a requisition, invoice, event, etc. 

Resolution

Check the locale or if necessary, change it for the affected user by clicking on the name in the top right corner of the screen and choosing Change default locale

Cause

Different countries officially designate different symbols for the decimal separator. The choice of symbol for the decimal separator also affects the choice of symbol for the thousands separator used in digit grouping. (Source: Wikipedia)

Countries where a dot is used as decimal separator include: Countries where a comma is used as decimal separator include:
   
Australia Albania
Bangladesh Algeria
Botswana Andorra
British West Indies Angola
Brunei Argentina
Cambodia Armenia
Canada (when using English) Austria
China, People's Republic of Azerbaijan
Hong Kong, China Belarus
Macau (in Chinese and English text) Belgium
Dominican Republic Bolivia
Egypt Bosnia and Herzegovina
El Salvador Brazil
Ghana Bulgaria
Guatemala Cameroon
Honduras Canada (when using French)
India Chile
Ireland Colombia
Israel Costa Rica
Japan Croatia
Jordan Cuba
Kenya Cyprus
Korea, North Czech Republic
Korea, South Denmark
Lebanon East Timor
Liechtenstein Ecuador
Luxembourg (uses both marks officially) Estonia
Malaysia Faroes
Maldives Finland
Malta France
Mexico Germany
Myanmar Georgia
Namibia (uses both marks) Greece
Nepal Greenland
New Zealand Hungary
Nicaragua Iceland
Nigeria Indonesia
Pakistan Italy
Palestine Kazakhstan
Panama Kosovo
Philippines Kyrgyzstan
Puerto Rico Latvia
Singapore Lebanon
South Africa (uses both marks)[22] Lithuania
Sri Lanka Luxembourg (uses both marks officially)
Switzerland (some cantons,[23] IT, always for currency) Macau (in Portuguese text)
Taiwan, China Macedonia
Tanzania Moldova
Thailand Mongolia
Uganda Morocco
United Kingdom Mozambique
United States (including insular areas) Namibia (uses both marks)[24]
Zimbabwe The Netherlands
  Norway
  Paraguay
  Peru
  Poland
  Portugal
  Romania
  Russia
  Serbia
  Slovakia
  Slovenia
  South Africa (uses both marks)[22][25][26][27]
  Spain
  Sweden
  Switzerland (for federal publications[28] and some cantons)
  Tunisia
  Turkey
  Turkmenistan
  Ukraine
  Uruguay
  Uzbekistan
  Venezuela
  Vietnam

 


Applies To

Core Procurement > Core Administration > Core Accounting
Core Procurement > Core Administration > Currency
Invoicing
Strategic Contracts
Strategic Sourcing

Terms of Use  |  Copyright  |  Security Disclosure  |  Privacy