PURPOSE
This document shows the detailed procedure of importing rate structures.
WHY IS THIS IMPORTANT?
This is important because it allows you to import multiple rate structures at a time and this saves time for the user.
PROCEDURE
1. From the Maintain Rate Structure screen, click Action and select New, then click Import. The Import Rate Structure screen will be displayed.
2. Click Template. An Excel file will be downloaded.
3. Open the file.
4. Fill in the fields as necessary. Input the Structure name. For currency discounting, input as “Ccy Discount”.
5. Input the Currency, As At Date, Tenor or number of days and the Rate accordingly.
6. Save the file to your local drive.
7. Go back to the system. From the Import Rate Structure screen, tick on the Read File checkbox.
8. Browse to look for the file that saved in your local drive.
9. Click Read File. The values entered in the Excel file will be displayed.
10. If there is an error, there will be a message informing the user of what is wrong. Simply go back to the saved Excel template and make the necessary corrections then click Read File and choose the file to re-upload.
11. Once everything is okay, click Load. A popup appears, click Yes.
12. A successfully loaded message will be displayed.
13. Click Cancel button to return to the main Rate Structure screen. Select the From Date and click Refresh. The imported rate structures will be displayed.
FREQUENTLY ASKED QUESTIONS
RELATED INFORMATION
Creating and Amending Rate Structure
CHANGE HISTORY
0 Comments