Common data > Common tables > Currencies 

This table is used to define the different currencies used in the software to characterize the monetary amounts entered. This table is defines only their principal characteristics ; the parities between currencies is defined in the exchange rate table.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

Presentation

Header identifying 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.

  • Title (field INTDES)

Destined notably to figure in the reports and the screens in which the record code can be entered or selected. This text is used to give a clear description to the record concerned.

  • field W

 

  • Short title (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 related to the currency are presented 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 Accounting

Presentation

The information linked to the account postings is presented in this tab.

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

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.

Table Analytical dimensions

 

An analytical dimension is an element of the analytical general ledger accounts.
This is divided into analytical axes where each axis constitutes a particular slice of the enterprise in a set of analytical destinations. The parameterisation of the folder permits the definition of 1 to 9 axes.
An analytical dimension is thus an analytical destination within a axis.
The dimensions set of an axis represent the 'Analytical plan' of the axis.

Close

 

Error messages

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

Format too long

The monetary format defined exceeds the possibilities offered.

Tables used

SEEREFERTTO Refer to documentation Implementation