> >

Use this form to create and view the currencies that your company uses and, in the lower pane, to maintain appropriate exchange rates between the company currency and other currencies.

When setting up General ledger, the company currency is created in this form and is then selected in the lookup field in the form.

In the lower pane, you can enter or view the current exchange rate for the currency that is selected in the upper pane. The exchange rate is expressed as the number of units of foreign (non-company) currency that is indicated in the field in the tab in the form.

Tip Tip

To export the company chart of accounts, dimension values, or exchange rates directly into the databases of subsidiaries or other companies that run on external databases, see Using AIF to integrate with external systems.


Tasks that use this form

Navigating the form

The following links and tables provide descriptions for the controls in this form.

Tabs

Tab

Description

Overview tab

Create or view the currencies that your company uses and enter basic identifying information for each currency.

General tab

Enter the gender of the currency that is selected on the tab.

Set up how the online numeric conversion tool is used for the currency that is selected on the tab.

The tool automatically converts transaction lines using the exchange rates in the lower pane.

Select posting accounts for realized and unrealized profits and losses that are related to the currency that is selected on the tab.

Enter rounding units and select the kind of rounding that applies to sales orders, purchase orders, and prices for the currency that is selected on the tab.

Set up exchange rates for consolidation.

This tab is only visible if you select the check box in the form.

Set up and maintain exchange rates for the currency that is selected in the upper pane.

Buttons

Button

Description

Create or update external codes to send and receive currency codes electronically through the AIF. For more information, see Using AIF to integrate with external systems.

Print a list of the currencies and the current exchange rates.

Send exchange rates electronically in an XML document, if you have set up the end point in the form. For more information, see How to: Send and receive electronic documents automatically.

Fields

Field

Description

The unique identifier – a code of up to three characters – for the selected currency.

Examples:

  • USD – U.S. dollar

  • EUR – Euro

  • CAD – Canadian dollar

A description of the selected currency.

The description, together with the currency code, is printed on checks and other documents.

Examples:

  • U.S. dollar

  • Euro

  • Canadian dollar

The standard code of the currency as defined by the International Organization for Standardization (ISO).

The symbol of the selected currency. Symbols are frequently used on reports.

Examples:

  • € – Euro

  • $ – U.S. dollar

Select if the selected currency has a feminine gender and the gender is used on checks and reports.

Note Note

(ESP) This field is available only if the configuration key for Spain is selected.


The default value for this field is , which, in effect, means no gender.

Select this check box to include the selected currency in the calculations of the online numeric conversion tool. The tool automatically converts amounts that are entered on transaction lines in the company currency to amounts in the selected currency.

Note Note

The amounts in the selected currency are not saved in the database but can be useful references.


Enter the text that is printed in front of the amount in the selected currency if the check box is selected.

Enter the text that is printed after the amount in the selected currency if the check box is selected.

The ledger account to which realized losses in the selected currency are posted.

The ledger account to which realized gains in the selected currency are posted.

The ledger account to which unrealized exchange adjustment losses for open transactions, in the selected currency, are posted.

For an example, see Unrealized exchange adjustment losses: an example.

The ledger account to which unrealized exchange adjustment gains for open transactions, in the selected currency, are posted.

Enter the unit for rounding off amounts, such as 0.10or 1.00.

Enter the unit for rounding off amounts on sales orders, such as 0.10or 1.00.

Select the rounding convention that applies to the number to the right of the round-off unit that is entered in the text box:

  • – Round up numbers 5 and higher and round down numbers 4 and lower.

  • – Round down all numbers.

  • – Round up all numbers.

Enter the unit for rounding off amounts on purchase orders, such as 0.10or 1.00.

Select the rounding convention that applies to the number to the right of the round-off unit that is entered in the text box:

  • – Round up numbers 5 and higher and round down numbers 4 and lower.

  • – Round down all numbers.

  • – Round up all numbers.

Enter the unit for rounding off prices, such as 0.10or 1.00.

Select the rounding convention that applies to the number to the right of the round-off unit that is entered in the text box:

  • – Round up numbers 5 and higher and round down numbers 4 and lower.

  • – Round down all numbers.

  • – Round up all numbers.

The first date on which the exchange rate is valid.

The exchange rate that is valid from the date in the field for the currency that is selected in the upper pane.

In forms and reports, exchange rates for currencies are shown as they are defined in this field.

Note Note

In the field in the form, you can change the number of units that the exchange rate is based on. The change is automatically reflected in the field in this form.

A typical setup for currency exchange rates expresses how much company currency is exchanged for 100 of the foreign currency that is selected in the upper pane.


Specify whether the exchange rate is included in triangulation.

Select this check box to use the government exchange rate when you run the VAT exchange adjustment batch.

Note Note

This field is available only if the configuration key is selected.


View an explanation of the exchange rate: the exchange rate per number of units of the foreign currency.

Enter the exchange rate that will be used for the selected currency when currency conversion occurs for the balances or transaction amounts of subsidiary ledger accounts. This occurs when the account amounts are added to consolidated company ledger accounts that have a value of in the field on the tab of the form.

Note Note

This field is only available for consolidated companies. To define a company as a consolidated company, select the check box in the form.

Accounts with a type of , , and are typically converted using a closing rate.


Enter the exchange rate that will be used for the selected currency when currency conversion occurs for the balances or transaction amounts of subsidiary ledger accounts. This occurs when the account amounts are added to consolidated company ledger accounts that have a value of in the field on the tab of the form.

Note Note

This field is only available for consolidated companies. To define a company as a consolidated company, select the check box in the form.

Accounts with a type of , , and are typically converted using an average rate or the historical rate for each transaction date. An average rate must be chosen with care, especially if there are large variations in the exchange rate during the period.


See Also