Setup > Common tables > Currencies 

This table is used to define the various currencies used in the software to characterize the monetary amounts entered. It defines only their main characteristics; the parity between currencies is defined in the table of currency rates.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

Presentation

The header identifies the currency.

Close

 

Fields

The following fields are present on this tab :

Code making it possible to identify the currency for a site, a Business Partner, or to define a default value. This code is controlled in the currency table. It is advisable to use the ISO coding 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 provides a description of the record.
It is used in some screens or reports when there is not enough space to visualize the long title.

Close

 

Tab General

Presentation

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

Close

 

Fields

The following fields are present on this tab :

Code

  • ISO code (field ISOCOD)

This coding is defined by taking the first two characters of the country initials with the last initial of the currency. (for example, USD for US dollars, GBP for British pounds, JPY for Japanese yen and 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.

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 deliminators. Examples: Maximum format limited to 13.2 significant figures : 13 numbers, 2 decimals and 5 deliminator spaces (#,###,###,###,###.##). Maximum format limited to 15 significant figures : 15 numbers, 0 decimals and 4 deliminator spaces (###,###,###,###,###). Maximum format limited to 12.3 significant figures : 12 numbers, 3 decimals and 4 deliminator spaces (###,###,###,###.###).

  • Format 2 (field FM2)

It concerns the format used for a small amount (for example unit price, discount). The format is variable with a limit of 10 significant characters. The format includes possible space deliminators. Examples: Maximum format limited to 6.2 significant figures : 6 integers, 2 decimals and 2 deliminator spaces (###,###.##). Maximum format limited to 8 significant figures : 8 integers, 0 decimals and 2 deliminator spaces (##,###,###). Maximum format limited to 5.3 significant figures : 5 integers, 3 decimals and 2 deliminator spaces (##,###.###).NB : The number of effective decimals in unit prices is determined by the variable GDECPRI.

  • 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 deliminators. Examples: Maximum format limited to 17.2 significant figures : 17 integers, 2 decimals and 1 deliminator space (#################,##). Maximum format limited to 20 significant figures : 20 integers, 0 decimals and 0 deliminator space (####################) . Maximum format limited to 16.3 significant figures : 16 integers, 3 decimals and 1 deliminator 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)

This indicator (where the value can change over time) signals that the currency is part of or not part of the Euro zone. If this is the case, the counter- value must be given for the currency in Euros in the field following this one (Euro rate); if not, the currency exchange rate will be determined in the classic fashion by the currency exchange rate table.

  • Euro rate (field EURRAT)

The counter-value of the currency in Euros is not entered here except if the currency is "in" the Euro zone. If this is not the case, the classic method of the currency exchange rate table is used.

  • 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.

Close

 

Tab Acct

Presentation

The information related to the accounting postings is displayed in this tab.

The accounting code of currency type can be considered in the setup of automatic journals for the elaboration of the accounts.

Close

 

Fields

The following fields are present on this tab :

Code

  • ISO code (field ISOCOD)

This coding is defined by taking the first two characters of the country initials with the last initial of the currency. (for example, USD for US dollars, GBP for British pounds, JPY for Japanese yen and 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.

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 deliminators. Examples: Maximum format limited to 13.2 significant figures : 13 numbers, 2 decimals and 5 deliminator spaces (#,###,###,###,###.##). Maximum format limited to 15 significant figures : 15 numbers, 0 decimals and 4 deliminator spaces (###,###,###,###,###). Maximum format limited to 12.3 significant figures : 12 numbers, 3 decimals and 4 deliminator spaces (###,###,###,###.###).

  • Format 2 (field FM2)

It concerns the format used for a small amount (for example unit price, discount). The format is variable with a limit of 10 significant characters. The format includes possible space deliminators. Examples: Maximum format limited to 6.2 significant figures : 6 integers, 2 decimals and 2 deliminator spaces (###,###.##). Maximum format limited to 8 significant figures : 8 integers, 0 decimals and 2 deliminator spaces (##,###,###). Maximum format limited to 5.3 significant figures : 5 integers, 3 decimals and 2 deliminator spaces (##,###.###).NB : The number of effective decimals in unit prices is determined by the variable GDECPRI.

  • 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 deliminators. Examples: Maximum format limited to 17.2 significant figures : 17 integers, 2 decimals and 1 deliminator space (#################,##). Maximum format limited to 20 significant figures : 20 integers, 0 decimals and 0 deliminator space (####################) . Maximum format limited to 16.3 significant figures : 16 integers, 3 decimals and 1 deliminator 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)

This indicator (where the value can change over time) signals that the currency is part of or not part of the Euro zone. If this is the case, the counter- value must be given for the currency in Euros in the field following this one (Euro rate); if not, the currency exchange rate will be determined in the classic fashion by the currency exchange rate table.

  • Euro rate (field EURRAT)

The counter-value of the currency in Euros is not entered here except if the currency is "in" the Euro zone. If this is not the case, the classic method of the currency exchange rate table is used.

  • 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.

Close

 

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

SEEREFERTTO Refer to documentation Implementation