Understanding How to Upload, Modify, and Purge Currency Exchange Rates
If you transact business in multiple currencies, you deal with exchange rate fluctuations on a daily basis. As an alternative to entering current exchange rates manually, you can upload them from an external source, such as a web site, into a JD Edwards EnterpriseOne work table.
The JD Edwards EnterpriseOne system stores currency exchange rates in the Currency Exchange Rate table (F0015). The system uses the values in the F0015 table when you process transactions that involve foreign currency. Currency exchange rates can change daily. To maintain current exchange rates in your system, you can upload currency exchange rates from the Czech National Bank.
To upload currency exchange rates from the Czech National Bank to the F0015 table:
Download the text file containing currency exchange rates from the web site that is provided by the Czech National Bank to a location from which you can upload the file.
You must have permissions to write to the location to which you upload the file, and you must have permissions to upload from the location to which you upload the file.
Use the Text File Processor program (P007101) to upload the text file to the Text Processor Header table (F007101) and Text Process Detail Table (F007111).
When you specify R74ZD030 as the upload program in the Text File Processor program, the system creates a batch and writes data from the F007101 and F007111 tables to the External Currency Exchange Rate table (F0015Z1).
For each record that it reads in the F007111 table, the system verifies that the currency code exists in the Currency Codes table (F0013). If the currency code does not exist in the F0013 table, the system does not write the record to the F0015Z1 table. Instead, the system generates a report indicating the missing currency code and tracks the number of errors.
Use the External Exchange Rate Revision program (P0015Z1) to verify and modify information in the batch that the system creates when you run the Text File Processor program.
Run the External Exchange Rate Processor program (R0015Z1).
The External Exchange Rate Processor program reads the data in the F0015Z1 table and writes data to the F0015 table.
Run the External Exchange Rates Purge program (R0015Z1P).
The External Exchange Rates Purge program purges exchange rate records from the F0015Z1 work table.
The text file that you import into the F007101 and F007111 tables must be in a specific format. The first record must be the date of currency conversion, the second record must be the titles, and the rest of the records must be the currency rates.