Interfacing exchange rates

You can interface currency exchange rates to currency tables from a non-Lawson file such as a spreadsheet. You can perform this procedure when you initially convert from a non-Lawson application to the Lawson General Ledger. You can also repeat this procedure periodically to update your currency exchange tables.

Before you interface exchange rate data, the currency codes, currency tables, and currency relationships that you are interfacing exchange rates must already exist in the Currency application. See the information about planning your original conversion in the Enterprise Financial Management Conversion Guide.

Financial Management File Layouts are available in KB2218730 in Infor Customer Portal. Complete these steps to interface exchange rates:

  1. Convert your non-Lawson file to a comma-separated-value (CSV) file. The fields in your CSV file must match the position, size, and type of the fields in the CUCONVREL (UNIX/Windows) or DBIFCUR (IBM i) Lawson interface file.
  2. Use a transfer utility program (such as ftp) to transfer your non-Lawson file to your environment.
  3. Import the file you transferred into the Lawson Currency Rate Interface file:CUCONVREL (UNIX/Windows) or DBIFCUR (IBM i), by using an Import command, such as:

    importdb productline CUCONVREL filename

    where productline is the Lawson productline where you want to load the file and filename is the file generated in step 2.

  4. (Optional) Generate a listing of updated rates before they are interfaced, using Rate Interface Listing (CU260).
  5. (Optional) View and maintain the information in the CUCONVREL (UNIX/Windows) or DBIFCUR (IBM i) file, on Currency Rate Interface Maintenance (CU60.1).
  6. Run Currency Rate Interface (CU160) to load the currency information into the Currency application. Use these guidelines to specify the field values:
    Currency Table

    Exchange rates are interfaced by currency table. This field is required.

    Replace Rate

    This field determines if existing rates defined for the currency table and currency relationships are replaced by rates with matching effective dates from the interface file.

    The default setting is No, which adds only new rates to the currency table.

    Update
    • Select N (No Report Only) in this field to view a report of the interfaced exchange rates without actually interfacing them.

    • Select A (All) in this field to interface all exchange rates if there is no error and to produce an error report without interfacing any rates if there is at least one error.

    • Select P (Partial) to interface only those exchange rates that are not in error and to produce an error report of non-interfaced rates.

    Note: As exchange rates interface successfully, they are deleted from the interface file: CUCONVREL (UNIX/Windows) or DBIFCUR (IBM i) and can be viewed and modified on Exchange Rates (CU10.1).
  7. Correct any records that did not interface on CU60.1, and run CU160 again. Repeat these steps until all records are interfaced.

Reports and inquiries

Action Process
List exchange rate interface records in the CUCONVREL (UNIX/Windows) or DBIFCUR (IBM i) file. Use Currency Rate Interface Listing (CU260)