Deleting historical exchange and translation rates

You can delete currency exchange and translation rate history for a date or date range to reduce the size of the exchange and translation rate files. You can delete exchange rates and translation rates at the same time or you can delete the exchange rates or the translation rates. You can delete exchange rates only if they are a year or more older than the system date. You can delete translation rates for any period, including the current fiscal year.

Follow these steps to delete historical exchange and translation rates:

Access Currency Rate History Delete (CU300).
Enter the deletion criteria. Use these guidelines to specify the field values:

Currency Table

You can specify or select the currency table from which you want to delete rates. If you leave these field blanks, then all the rates will be deleted from all the currency tables for the range date (exchange rates) and fiscal year (translation rates).

Delete Exchange Rate Dates

If you want to delete exchange rates, you must specify a range of effective dates for which rates will be deleted. You must specify at least the beginning date. If you leave the end date field blank, then the beginning date becomes the default value.

Note: The exchange rates must be at least one year older than the system date.

Fiscal Year

If you want to delete translation rates, then you must specify the fiscal year for which you want to delete translation rates.

Note: You can delete translation rates for any fiscal year, including the current year.

Company

To delete translation rates defined for a specific company, specify the fiscal year and company number.

Budget

To delete translation rates defined for a specific budget, specify the fiscal year and budget number.