Importing daily exchange rates
Menu path
Go to Financial ? Setup ? General ? Currencies, and then click Import: XRate.
Introduction
On this page, you can import the daily
exchange rates against the default currency in the CSV format and view the
import results.
Description
To create the daily exchange rates CSV file
in Microsoft Excel, you should follow the format as shown in the following:
The first column displays the targeted
currency codes, the second column displays the currency description, and the
third column displays the exchange rates of the targeted currencies against the
default currency on a particular day.
Roles & rights
To import the daily exchange rates,
function rights 391 – XML Upload: Currency exchange rate and 500 –
XML Upload: Currency are required. By default, users with the General
manager, Controller, XML Administrator, and XML User
roles have these function rights.
Note:
-
For more details on function rights, go to
Modules ? System ? Setup ? Security ? Function rights.
-
For more details on roles, go to Modules ? System ? Setup ? Security ? Roles.
What version are you using?
The information in this document is
applicable to product update 257 and higher. If you have versions lower than
this, certain features explained here will not be applicable.
How do I import exchange rates?
- On the Financial: Import exchange rates page, define the
fields under the Data section.
-
Click Import.
- The results of the import will then be displayed on the page. By
default, there will be two rows displayed for the exchange rates and currencies
that have been created, updated, or rejected.
Fields
Default currency
This field displays the default currency
which the exchange rates are against. You cannot change the default currency.
You can click the currency link to open the settings screen for the currency.
This default currency is the currency you have selected when you define the
financial settings. For more information, see Defining financial settings.
XRate type
This field displays the exchange rate type
that can be imported, which are Daily and Period. By default, the
Daily exchange rate type is selected.
Date
Type or select the exchange rate date. By
default, it will display the current date.
File
Click Browse to search for the
exchange rates CSV file which you want to import.
Buttons
Import
Click this button to import the selected
CSV file that contains the daily exchange rates of various currencies against
the default currency. The system will validate the file before the import
process starts. If the file is not in the CSV format, the message “Invalid
file” will be displayed after you have clicked this button.
Close
Click this to exit.
Related documents
Main Category: |
Support Product Know How |
Document Type: |
Online help main |
Category: |
On-line help files |
Security level: |
All - 0 |
Sub category: |
Details |
Document ID: |
16.036.652 |
Assortment: |
Exact Synergy Enterprise
|
Date: |
08-05-2018 |
Release: |
|
Attachment: |
|
Disclaimer |