PURPOSE
This document shows the detailed steps on how to import exchange rates into the system.
WHY IS THIS IMPORTANT?
Importing is the best and fastest way to enter multiple exchange rates into the system. It is an important procedure when maintaining exchange rates in the system.
PROCEDURE
1. From the main menu, navigate to Prices > Exchange Rate.
2. Click Add. The New Exchange Rate Maintenance screen will be shown.
3. Click Import. On the Import Exchange Rate screen, click on Template. The system downloads an Excel file titled, “Load_Excrate_Template.xls.” Save the file then open it. The Excel file is as shown below:
4. Fill out the column fields in the import template. Enter the VDate, the corresponding currency, and Valuation rates. Accounting, Alternate, Volatility, and Ex Rate Type are optional fields. In the example below, we will input USD and AUD valuation rates for 1-Jul-2017.
5. When finished, save the import template, noting the name and location to which you save it, and return to the CS Lucas system.
6. To import the file, place a check on Read File checkbox.
7. Click on Choose File. Look for the Excel file saved earlier. Then click on the Read File button to read the file.
8. If there is an error, the system will prompt the user as to which row has the error. If there are none, you will see the Load button. Once the button is clicked, the system will prompt that the exchange rates are loaded successfully.
9. Click on Cancel button to return to the Exchange Rates Maintenance screen. Select the VDate accordingly and click Refresh, newly imported exchange rates will be displayed.
RELATED INFORMATION
CHANGE HISTORY
0 Comments