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

Decimal separator in money fields shows as comma rather than point or vice versa.


Resolution
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:
AustraliaAlbania
BangladeshAlgeria
BotswanaAndorra
British West IndiesAngola
BruneiArgentina
CambodiaArmenia
Canada (when using English)Austria
China, People's Republic ofAzerbaijan
Hong Kong, ChinaBelarus
Macau (in Chinese and English text)Belgium
Dominican RepublicBolivia
EgyptBosnia and Herzegovina
El SalvadorBrazil
GhanaBulgaria
GuatemalaCameroon
HondurasCanada (when using French)
IndiaChile
IrelandColombia
IsraelCosta Rica
JapanCroatia
JordanCuba
KenyaCyprus
Korea, NorthCzech Republic
Korea, SouthDenmark
LebanonEast Timor
LiechtensteinEcuador
Luxembourg (uses both marks officially)Estonia
MalaysiaFaroes
MaldivesFinland
MaltaFrance
MexicoGermany
MyanmarGeorgia
Namibia (uses both marks)Greece
NepalGreenland
New ZealandHungary
NicaraguaIceland
NigeriaIndonesia
PakistanItaly
PalestineKazakhstan
PanamaKosovo
PhilippinesKyrgyzstan
Puerto RicoLatvia
SingaporeLebanon
South Africa (uses both marks)[22]Lithuania
Sri LankaLuxembourg (uses both marks officially)
Switzerland (some cantons,[23] IT, always for currency)Macau (in Portuguese text)
Taiwan, ChinaMacedonia
TanzaniaMoldova
ThailandMongolia
UgandaMorocco
United KingdomMozambique
United States (including insular areas)Namibia (uses both marks)[24]
ZimbabweThe 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