Amounts and Decimals

When importing currency amounts, many different numeric formats can be used.

Explicit Decimal Places Decimal points can be explicitly noted in the external data file, for example, $100 (USD) would be noted as 100.00.

Implied Decimal Places An implied number of decimal places can be specified in the definition file (position 5 in fixed-width formatted data files and position 7 in CSV formatted data files), such as the following example:

TETRANS_CREDIT,5,0,,,,2

If "2" is noted as the implied number of decimal places in the definition file, "10000" would be interpreted as 100.00.

If a decimal point is provided in the data file and a number other than zero is indicated as the implied number of decimal places or it is left out, the import process moves the decimal point to the left of the number of spaces indicated by the value in this position. For example, if the implied decimal place is two (2) but the value provided in the definition file is "00900.00," the value imported would be 9.00.

Commas Instead of Decimals

The currency formatting used throughout the system is based on the settings specified by the Administrator using the Organization>Currency Setup form. You can set up different currency formatting for each currency type (such as USD or CAD) used in the system. To determine the decimal and grouping symbols used in reports, also use this form.

Other decimal and grouping symbols (such as the period and comma), found throughout the system, follow the computer's regional settings (Start>Settings>Control Panel>Regional Options or Control Panel>Change date, time, or number formats>Additional Settings Button). All non-currency numbers follow the computer's regional settings as well.

Note that if you are using regional settings with a comma in place of a decimal point (such as with EUR or CRC), the data will not import. You must change the regional settings to a period, import the data, and then change it back to a comma.