Common data > Common tables > 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

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

Presentation

Use the header to determine the currency.

Close

 

Fields

The following fields are present on this tab :

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.

Close

 

Tab General

Presentation

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

Close

 

Fields

The following fields are present on this tab :

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.

For the Euro currency in particular, this check box must be selected.

  • 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 changeover 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 Accounting

Presentation

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

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

 

Fields

The following fields are present on this tab :

Block number 1

The code makes it possible to define the forms of accounting posting for entries automatically generated by the software package.

The accounting codes are associated with the base data (customer, product, currency) and define the ensemble of accounts or modifiers (sales or purchase account, associated collective) and natures to be used at the automatic generation time of entries in accounting.

During the parameter setting of Entry diagrams, the list of accounting codes to be used should be given as well as the priority for assignment of the accounting codes between them.

Grid

This grid is automatically initialized with the default dimension views associated with the 'Currency' basic data.

An analytical dimension is an element of the analytical chart of accounts on which accounting entries can be posted.

Each analytical dimension type represents a specific division of the company into a set of analytical payment attributes.

An analytical dimension is thus an analytical payment attribute within a dimension type.

 

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