Why Currency Import ??
Currency Import is an alternative way to add Currency details into DOKA.
Upload saves time and allows many Currencies to be added in bulk.
How to Import Currency :
Importing of currency comprises of two steps mainly
1. Importing of files into the system using SFTP
2. Processing of the Imported file using IMPCUR
Field Mapping
FIELD | DESCRIPTION | SIZE |
Currency Description | Description of the cur maintained | 15 |
Currency Code | Code | 3 |
Exchange Rate Calculation Base (1, 100, 1000) |
||
Decimal Places (0, 2, 3) |
Decimals allowed | 3 |
Maximum Tolerance |
Maximum Tolerance | 1,2 |
General Ledger Balance Rate |
Balance rate | 1,6 |
Margin for Buying/Selling Rate |
selling rate | 1,6 |
Let us look into this in detail :
Importing of files :
Follow article FTP - File transfer using Putty to know more about FTP
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 transferred .Do a drag and drop
3.Execute the command in DOKA .Incase of Currency upload follow section Processing of files
Processing of files :
Transaction IMPCUR:
This transaction is used to import 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 BATIN 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 "IMPCUR".
2.Select the file path and file name from the drop down available
3.Click upload Icon on top left
4.User can check logs to know the status of the upload using icon
Check the Below Gif for uploading and processing of Currency Import
Saved Record can be queried in "DBICUR" and checked
Refer file "cur_imp(1).txt" attached
Comments
0 comments
Please sign in to leave a comment.