This chapter contains the following topics:
Section 4.1, "Understanding How to Upload, Modify, and Purge Currency Exchange Rates"
Section 4.2, "Setting Processing Options for the Actual Exchange Rate Processing Program (R74ZD030)"
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.
Before you perform the tasks in this section:
Verify that you have permissions to write to and read from the location to which you save the text file from the Czech National Bank.
Verify that all ActiveX components are enabled when downloading the file from the Czech National Bank.
Verify that the currency codes in the downloaded file exist in the F0013 table.
Verify that the value R74ZD030 exists in the Upload Text Program (03B/UP) UDC table.
Processing options enable you to set default values for processing.
Enter a currency code that exists in the Currency Codes table.
Enter the calculation method that the system uses for the exchange rate. Values are:
Blank or 1: Inverse
2: No inverse
Enter the method that the system uses for the currency conversion. Vales are:
Y: Multiplier
Z: Divisor
Enter 1 to enable the override of the currency when you enter a transaction. Leave this processing option blank to have the system use only the currency rate that exists in the Currency Exchange Rates table (F0015).
Enter the character that the system uses as a separator in the text file. If you do not enter a character, the system separates records in the text file with the character | (pipe).