Interfacing translation rates

You can interface currency translation 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 translation tables.

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

File layouts are available on the Documentation page on Infor Support Portal. Complete these steps to interface translation 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 CUTRATEREL (UNIX/Windows) or DBIFCUL (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 Translation Rate Interface file: CUTRATEREL (UNIX/Windows) or DBIFCUL (IBM i), by using an Import command, such as importdb productline CUTRATEREL filename

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

  4. (Optional) Generate a listing of interfaced rates before they are interfaced, using Translation Interface Listing (CU261).
  5. View and maintain currency table translation rate information in the CUTRATEREL (UNIX/Windows) or DBIFCUL (IBM i) file, on Maintain Translation Rates (CU61.1).

    Alternatively, view and maintain company translation rate information in the CUTRATEREL (UNIX/Windows) or DBIFCUL (IBM i) file, on Maintain Co Translation Rate (CU61.2).

  6. Run Interface Translation Rates (CU161) to load the currency information into the Currency application. Use these guidelines to specify the field values:
    Currency Table / Company / Company Group

    Translation rates are interfaced by currency table, company, or company group. One of these fields is required.

    Fiscal Year

    This is a required field. Specify the year for which you are interfacing rates.

    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 translation rate 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.

    From Currency

    This is the currency code from which balances are translated.

    To Currency

    This is the currency code to which balances are translated.

    Budget

    Specify or select the budget number for the translation rate.

    Note: As translation rates interface successfully, they are deleted from the interface file: CUTRATEREL (UNIX/Windows) or DBIFCUL (IBM i) and can be viewed and modified using Currency Table Translation Rates (CU20.1) or Company Translation Rates (CU20.3).
  7. Correct any records that did not interface using CU61.1, and run CU161 again. Repeat these steps until all records are interfaced.

Related reports and inquiries

Action Process
List translation rate interface records in the CUTRATEREL (UNIX/Windows) or DBIFCUL (IBM i) file. Use Translation Interface Listing (CU261)