Field Descriptions

Table Information

 

Exchange Rates by Date

What can I do in this screen?

Use this screen to select a date or a range of dates in which you plan to use foreign currency exchange rates. You must enter the rates in chronological order, with each row entered for a later fiscal period than the rows above.

When should I use this screen?

You can enter daily exchange rates at any time and these rates can be for one day or for a range of days.

Field Descriptions

Exchange Rate Information

Rate Group

Use Query to enter the rate group in this field.

The unnamed field to the right displays the rate group description.

Rate Source

This field displays the rate source that is currently activated for this rate group.

The unnamed field to the right displays the rate source description.

Currency From

This field displays the currency code that will be translated.  The unnamed field to the right displays the formal name.

Currency To

This field displays the currency code into which this row's Currency From will be translated.  The unnamed field to the right displays the formal name.

Table Window

Starting Date *

After selecting the New Line button on the toolbar, enter the starting date for this currency rate.

Ending Date

Enter the ending date for the currency rate. This field is optional.

Rate Amount *

Enter the rate for the ending date in this row.

Change %

This column displays the change percentage. Costpoint calculates this information by subtracting the prior rate amount from the current rate amount, then dividing this result by the prior rate amount. 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 daily rates, only the edited row will be re-evaluated for fluctuation limits.

Notes

Enter any notes (up to 254 alphanumeric characters) to be used in reference to this currency conversion.

* A red asterisk denotes a required field.

Table Information

Changes to this screen update the following tables:

RT_GRP_CRNCY (Rate Group Currency)

RT_BY_DT (Rate By Date)

Top of Page