Exchange Rates Accounts Receivable History Subtask

Use the Exchange Rates subtask on the Manage Accounts Receivable History screen to review and edit AR transactions that occur in a currency other than your company's functional currency.

Contents

Field Description
Invoice Number

This field displays the AR invoice number from the main screen.

Customer Account

These fields display the customer account number from the main screen.

Customer Name

This field displays the customer name from the main screen.

Transaction Currency

This field displays the transaction code. The transaction description displays in the adjacent, non-editable field.

The transaction code represents the currency specified on the invoice.

Costpoint populates this field by first retrieving data from the Transaction field of the Multicurrency subtask of the Manage Customers screen. If this field does not display data, Costpoint retrieves data from the Billing Currency field in the Other Info tab of the Project Billing Information screen, if applicable. In this circumstance, the Transaction Currency fills with the data in the Billing Currency field that is specific to the project entered on the invoice. Finally, if this field does not display data, Costpoint retrieves data from the Default Transaction field of the Configure Multicurrency Settings screen.

You can enter, or click to select, a different transaction code.

The data available in the originates from the Manage Currencies screen.

The Japanese Yen (JPY), for example, might represent the transaction code on an invoice sent to a company in Japan by a company in the United States.

The transaction code prints on the invoice.

Rate Group

This field displays the rate group code. The rate group description displays in the adjacent, non-editable field.

The rate group allows you to compare one currency to another.

Costpoint populates this field by first retrieving data from the Rate Group field of the Multicurrency subtask of the Manage Customers screen. If this field does not display data, Costpoint retrieves data from the Billing Currency field in the Other Info tab of the Project Billing Information screen, if applicable. In this circumstance, the Transaction Currency fills with the data in the Billing Currency field specific to the project entered on the invoice. Finally, if this field does not display data, Costpoint retrieves data from the Default Rate Group field of the Configure Multicurrency Settings screen.

You can enter, or click to select, a different rate group code.

The data available in the originates from the Manage Exchange Rate Groups screen.

The "Daily" rate group, for example, might display 10 records. One record might compare the U.S. Dollar (USD) to the Japanese Yen (JPY), another record might compare the Dutch Gilder (NLG) to the British Pound (GBP), and the eight remaining records might include various other currency comparisons.

The rate groups that you create establish a relationship between currencies. This association must exist in order for you to determine exchange rates in this subtask.

Transaction Currency to Functional Currency Exchange Rate Info

Field Description
Rate Date

This field displays the date used to calculate the exchange rate for this invoice.

If your currency exchange rates are tracked by date, the exchange rate used for this billing-to-functional is the date or range of dates in which this invoice date falls. Costpoint first looks to exchange rates by date, then to exchange rates by period. This field is editable.

If your currency exchange rates are tracked by period, the transaction rate used for this billing-to-functional exchange is the period rates (period end rates for the last day of the period, and period average rates for all other dates) in which this rate date falls.

Rate

This field mimics the Billing to Func rate when non-Euro currencies are used. When you use a Euro currency, this field is the product of the Billing to Euro and Euro to Func fields.

Freeze Rate

Select this check box to hold the last rate saved in these fields. You can enter other rates into Costpoint, but they are not applied to this invoice (for gain or loss calculation) unless this check box is cleared.

Trans to Func

This field displays the transaction to functional exchange rate if you calculate the exchange rate for a non-Euro currency.

Find Rates

Click this button to refresh the fields in this group box and retrieve updated exchange rate information using data in the Transaction Currency, Rate Group, and Rate Date fields.

If you add or modify data in this subtask, you must click this button to display new, recalculated exchange rate information.

N/A

This non-editable field displays 1.0000000 if you calculate the exchange rate for a non-Euro currency.

Apply

Click this button to update information on the Manage Accounts Receivable History screen and its applicable subtasks with new exchange rate information.

Note: The update to information will only happen if you click the Apply button and not when you close or select another screen outside the Exchange Rates subtask.