Exchange Rate Import - IMPXRT – DOKA-SaaS Help & Support

Rates can be maintained using the Maintain exchange rates screens , or can be imported using a feed from your core banking system .

The Upload Exchange Rate Import transaction (IMPXRT) allows you to bulk upload currency exchange rates. This article describes the way to upload File, to check the uploaded record and columns supported in the upload file .

Because Exchange rates move over time , there is a flag to reset the general ledger base rate in the Currency definition to be last nights exchange rate.
If not used, then you will occasionally need to maintain the currency to reset the g/ base rate

Structure

The import file has to be structured as follows:

currency: 3 digits, 3 spaces
system currency: 3 digits, 3 spaces
code: 2 digits, 3 spaces (B=selling rate; G=buying rate; M=middle rate; H =Selling rate 1, C = Buying Rate 1
rate: 15 digits, 3 spaces
rate format with “,” as decimal delimiter
translation unit of currency: 4 digits, 3 spaces (siehe Column “BAS” in Table CUR)
translation unit of system currency: 4 digits, 3 spaces
date (YYYYMMDD): 8 digits, 23 spaces

Field Mapping

Fieldname	Description	Datatype	max. Size
Currency	Currency to be mapped	Text	3
System currency	Currency	Text	3
Code	(B=selling rate; G=buying rate; M=middle rate; H =Selling rate 1, C = Buying Rate 1	Text	2
Rate	Exchange Rate	Text	15
Rate format	Decimal delimiter	Text
Translation unit of currency		Text	4
Translation unit of system currency		Text	4
DATE	YYYYMMDD Format	Text	8

How to Import Exchange Rate :

Importing of Exchange Rate comprises of two steps mainly
1. Importing of files into the system using SFTP Refer Section Importing files

2. Processing of the Imported file using IMPXRT

Please follow the below gif and the step mentioned to upload files into the system :

1.Set up the putty configuration as shown

2.Select the file to be transferred .Do a drag and drop to path "/giga/tfaas_p/customers/customername/data/xrtin"

3.Execute the command in DOKA. In case of Exchange rate upload follow section Processing of files

Processing of the Imported file using IMPXRT

This transaction is used to import Exchange rate for the specified currency into the database of the application.
The text file to be imported is selected via path and file name and will be imported by clicking the icon.
The log file for this transaction can be displayed by clicking the icon . The log shows information about the updated and added records.
Note: The subdirectory XRTIN must be created in the DATA directory of the application. The converted import file has to be in that subdirectory. The structure of the import file has to be available in ASCII format and has to have a .txt extension.

The following steps are needed process the imported file :

1.Navigate to transaction "IMPXRT".

2.Select the file path and file name from the drop down available

3.Click upload Icon on top left