Common data >  Common tables >  Currencies  

Display all Hide all

Use this table 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

Use the header to determine 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.

  • field W

 

  • Short description (field INTSHO)

This title, which provides a description of the record, is used in some screens or records 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)

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 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 :

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 t he base data (customer, product, currency...) and define the ensemble of accounts or modifiers (sales or purchase account, associated collective...) and of natures to be used at the time of automatic generation of entries in accounting.

Dur ing 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.

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