MAINTAIN EXCHANGE RATES BY PERIOD

Use this screen to create and view a history of currencies that your company tracks by period. This combination of rate group, rate source, and currencies (both to and from) represents one line of the child table created on the Enter Period Rates screen. You can edit these rates after saving them.

Use this screen to enter rates for currencies that you track only by period-end or period-average rates. We suggest that you use this kind of tracking only for currencies that are consistently stable.

Rate Group

Use Find or Query to select the rate group for this screen. Your selection will include the currency combination (from/to) that was created in the Maintain Exchange Rate Groups screen. The field to the right displays the rate group description.

Rate Source

This field displays the rate source code that has been linked with this rate group. The field to the right displays the rate description.

Currency From

This field displays the currency code. The code's formal name is displayed in the field to the right.

Currency To

This field displays the currency code. The code's formal name is displayed in the field to the right.

Table Window

Select the New Line button on the toolbar to enter a new row.

Fiscal Year

Enter the fiscal year to be used for this period's exchange rate.

Period

Enter the fiscal period for this exchange rate.

Period Start Date

This column displays the period start date based on the Fiscal Year and Period combination you selected.

Period End Date

This column displays the period end date based on the Fiscal Year and Period combination you selected.

Period-End Rate

Enter the exchange rate to be used for period-end currency conversion. When you use period (rather than daily) rates, this rate will default for those transactions with a rate date of the last day of the period.

Period-End Rate Change %

This field displays the period-end rate change percentage. Costpoint calculates this by subtracting the prior period-end rate from the current period-end rate, then dividing this result by the prior period-end rate. You cannot edit this column.

The exchange rate that you entered may not be allowed, depending on the allowable limit entered on the Maintain Exchange Rate Groups screen. If the fluctuation limit for this currency from/to combination is 5%, you cannot enter any rate that is a change (either positive or negative) of more than 5%. However, if you edit any pre-existing rows of period rates, only the edited row will be re-evaluated for fluctuation limits.

Period-Average Rate

Enter the exchange rate to be used for period average currency conversion.

Period-Average Rate Change %

This field displays the period-average rate change percentage. Costpoint calculates this by subtracting the prior period-average rate from the current period-average rate, then dividing this result by the prior period-average rate. You cannot edit this field.

The exchange rate that you entered may not be allowed, depending on the allowable limit entered on the Maintain Exchange Rate Groups screen. If the fluctuation limit for this currency from/to combination is 5%, you cannot enter any rate that is a change (either positive or negative) of more than 5%. However, if you edit any pre-existing rows of period rates, only the edited row will be re-evaluated for fluctuation limits.

Notes

Enter up to 254 alphanumeric characters to create notes about your exchange rate.

Table Information

Changes to this screen update the following tables:

RT_GRP_CRNCY

RT_BY_PD