Skip to content

ERP ReferenceMaster data codes

Guide

Currency minor units and decimal places in ERP

Why not every currency has two decimals, how ISO 4217 minor units differ from CLDR fraction digits, and what to check in your ERP currency setup.

Checked against sources on . Related lists: ISO 4217

Not every currency has two decimals

Most currencies are written with two decimals, but not all. In the Unicode CLDR data used on this site, these active currencies have zero fraction digits: AFN, ALL, BIF, CLP, COP, DJF, GNF, HUF, IDR, IQD, IRR, ISK, JPY, KMF, KPW, KRW, LAK, LBP, MGA, MMK, PKR, PYG, RWF, SOS, SYP, UGX, UYI, VND, VUV, XAF, XOF, XPF, YER. These have three: BHD, JOD, KWD, LYD, OMR, TND.

Sources: npmjs.com/package…48.2.0

ISO 4217 minor unit vs CLDR fraction digits

ISO 4217 itself has a minor-unit column. ISO's list is not openly licensed, so this site does not republish it. Instead it shows CLDR's fraction digits, which are CLDR's own data: CLDR uses 2 when it gives no specific value, and its values are not guaranteed to match the ISO column. If an exact ISO minor unit matters (for example for a payment file format that references ISO 4217 directly), check the list published by ISO's maintenance agency.

Sources: npmjs.com/package…48.2.0

Cash rounding is a separate setting

CLDR also records where cash amounts are rounded differently from accounting amounts. For these currencies CLDR gives separate cash digits or a cash rounding increment: AMD (0 cash digits); CAD (rounding increment 5); CHF (rounding increment 5); CRC (0 cash digits); CZK (0 cash digits); DKK (rounding increment 50); GYD (0 cash digits); HUF (rounding increment 5); MNT (0 cash digits); MUR (0 cash digits); NOK (0 cash digits); RSD (0 cash digits); SEK (0 cash digits); TWD (0 cash digits); TZS (0 cash digits); UZS (0 cash digits).

Sources: npmjs.com/package…48.2.0

What to check in your ERP

ERP systems usually keep decimal places per currency. In Business Central, for example, each currency has its own amount decimal places, amount rounding precision and unit-amount decimal places, next to its ISO Code and ISO Numeric code. When you add a currency, set these deliberately instead of keeping a two-decimal default.

Sources: github.com/MicrosoftDocs…finance-set-up-currencies.md

Limitations