Currencies

Use this table to define the various currencies used in the software to characterize the monetary amounts entered. It sets only their main characteristics. The parity between currencies is defined in the table of currency rates.

Prerequisite

Refer to documentation Implementation

Screen management

Use the header to determine the currency.

Currency (field CUR)

This code helps identify the currency for a site, a business partner, or define a default value. This code is controlled in the currency table. It is advisable to use the ISO code during the creation of a new currency.
Description (field INTDES)

Enter the description of the relevant record.

This long description is used as a title in screens and reports.
Short description (field INTSHO)

This title, which describes the record, is used in some screens or records when there is not enough space to display the long title.

Tab General

The general information relating to the currency is displayed in this section.

Code

ISO code (field ISOCOD)

The first two letters of the ISO 4217 three-letter code are the same as the code for the country name, and, where possible, the third letter corresponds to the first letter of the currency name. For example:

  • USD for US dollars
  • GBP for British pounds
  • JPY for Japanese yen
  • EUR for the Euro (which is an exception to the rule described above)

It is advisable to use this standard ISO coding as the currency code.
Symbol (field CURSYM)

The code is the normal symbol for a currency, appearing before or after an amount in a document.

Numeric ISO code (field ISONUMCOD)

Three-digit numeric code of the currency. The numeric code assigned to a currency by ISO 4217 is usually the same as the numeric code assigned to the corresponding country by ISO 3166-1.

For example, 840 is the numeric ISO code for USD (United States dollar) and also the numeric code for the US (United States).

Format

Format 1 (field FM1)

It concerns the format used for a standard amount (for example invoice amount inclusive of tax). The format is variable with a limit of 20 significant characters. The format includes possible space delimiters.

Examples:

  • Maximum format limited to 13.2 significant figures: 13 numbers, 2 decimals and 5 delimiter spaces (#,###,###,###,###.##)
  • Maximum format limited to 15 significant figures: 15 numbers, 0 decimals and 4 delimiter spaces (###,###,###,###,###)
  • Maximum format limited to 12.3 significant figures: 12 numbers, 3 decimals and 4 delimiter spaces (###,###,###,###.###)
Format 2 (field FM2)

It concerns the format used for a small amount (for example, a unit price or discount). The format is variable with a limit of 10 significant characters. The format includes possible space delimiters.

Examples:

  • Maximum format limited to 6.2 significant figures: 6 integers, 2 decimals and 2 delimiter spaces (###,###.##)
  • Maximum format limited to 8 significant figures: 8 integers, 0 decimals and 2 delimiter spaces (##,###,###)
  • Maximum format limited to 5.3 significant figures: 5 integers, 3 decimals and 2 delimiter spaces (##,###.###)

The number of effective decimals in unit prices is determined by the GDECPRI variable.
Format 3 (field FM3)

This concerns the format used by the totaled amount (for example, balance totals or statistics). The format is variable with a limit of 20 significant figures. The format includes possible space delimiters.

Examples:

  • Maximum format limited to 17.2 significant figures: 17 integers, 2 decimals and 1 delimiter space (#################,##)
  • Maximum format limited to 20 significant figures: 20 integers, 0 decimals and 0 delimiter space (####################)
  • Maximum format limited to 16.3 significant figures: 16 integers, 3 decimals and 1 delimiter space (################,###)
Decimals (field DECNBR)

Entered here are the significant decimal numbers for the amount expressed in the currency.

Rounding (field CURRND)

The field is the rounding associated with this currency. All amounts in this currency will be rounded to this precision.

Conversion

Euro (field EURFLG)

Select this check box to indicate that the currency is part of the euro area. In this case, you must enter the counter-value of this currency in euros, in the Euro rate field.
Euro rate (field EURRAT)

This field can only be accessed when the currency is part of the euro area (the Euro check box is selected). In this case, enter the counter-value of this currency in euros. If the currency is not part of the euro area, use the table of exchange rates (classic method).

For the Euro currency, in particular, the exchange rate must be set to 1.

Euro conversion date (field EURDAT)

Date from which the Euro is used in addition to the currency.

Currency end date (field CURENDDAT)

Date from which the currency is no longer in circulation, there will be no more exchange rates.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

Format too long

The defined monetary format exceeds the possible length.

Tables used

Refer to documentation Implementation