UPDATE OPEN ACCOUNTS PAYABLE EXCHANGE RATES
Use the Update Open Accounts Payable Exchange Rates screen to load currency exchange rates into Costpoint Accounts Payable. This ensures that Costpoint will use the most current rates when calculating gains and losses.
If you do not use this screen before selecting vouchers for payment, out-of-date exchange rates may be used for these transactions. This could result in an inaccurate recognition of gains or losses on foreign currency transactions. This screen is especially important when exchange rates fluctuate substantially between the time vouchers are entered and the time they are paid.
Run this process before you select vouchers for payment and compute unrealized gains and losses.
Location
Identification
Use the fields in this block to create a new parameter ID or to retrieve
a previously saved parameter ID. A parameter ID represents a set of screen
selection parameters. After you have saved a parameter ID and its related
parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes
more efficiently and with greater consistency. The saved parameters are
also useful and necessary when you want to run the process as part of
a batch job. Many users save a unique set of parameters for each different
way they run a report or process. When you select a previously saved parameter
ID or parameter description, the associated saved screen selection parameters
automatically display as selection defaults. The page setup and print
options are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
Parameter ID
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are
stored with the parameter ID. Later, you can retrieve the parameter using
Query.
You can use the parameter to run the process more efficiently because
you can select the parameter ID with its previously defined screen selections.
After the default selections display in the screen, you can override the
defaults.
Description
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Selection Ranges: (Select By)
(Select By)
Select a selection criteria. The options are Cash Account, AP Account, or Bank Abbreviation.
Option
Select the range of accounts or abbreviations to include. The options are:
-
All — Select this option to include all accounts or abbreviations. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one account or abbreviation and enter that account or abbreviation in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of accounts or abbreviations. Enter the beginning account or abbreviation for the range in the Start field and enter the ending account or abbreviation of the range in the End field.
-
From Beginning — Select this option to include a range of accounts or abbreviations that begins with the first of all the available accounts or abbreviations and ends with the account or abbreviation that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of accounts or abbreviations that begins with the account or abbreviation that you enter in the Start field and ends with the last of all the available accounts or abbreviations. The End field is disabled for this option.
Start/End
Enter, or click 
to select, the starting accounts or abbreviations, ending accounts or abbreviations, or both for the range of accounts or abbreviations to be included in the process. Depending on your selection in Option, one or both of these fields may be inactive.
Organization
Option
Select the range of organizations to include. The options are:
-
All — Select this option to include all organizations. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one organization and enter that organization in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of organizations. Enter the beginning organization for the range in the Start field and enter the ending organization of the range in the End field.
-
From Beginning — Select this option to include a range of organizations that begins with the first of all the available organizations and ends with the organization that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of organizations that begins with the organization that you enter in the Start field and ends with the last of all the available organizations. The End field is disabled for this option.
Start/End
Enter, or click to select, the starting organization, ending organization, or both for the range of organizations to be included in the process. Depending on your selection in Option, one or both of these fields may be inactive.
Voucher
Option
Select the range of vouchers to include. The options are:
-
All — Select this option to include all vouchers. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one voucher and enter that voucher number in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of voucher numbers. Enter the beginning voucher number for the range in the Start field and enter the ending voucher number of the range in the End field.
-
From Beginning — Select this option to include a range of voucher numbers that begins with the first of all the available voucher numbers and ends with the voucher number that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of voucher numbers that begins with the voucher number that you enter in the Start field and ends with the last of all the available voucher numbers. The End field is disabled for this option.
Start/End
Enter, or click to select, the starting voucher number, ending voucher number, or both for the range of voucher numbers to be included in the process. Depending on your selection in Option, one or both of these fields may be inactive.
Pay Vendor
Option
Select the range of pay vendors to include. The options are:
-
All — Select this option to include all pay vendors. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one pay vendor and enter that pay vendor in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of pay vendors. Enter the beginning pay vendor for the range in the Start field and enter the ending pay vendor of the range in the End field.
-
From Beginning — Select this option to include a range of pay vendors that begins with the first of all the available pay vendors and ends with the pay vendor that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of pay vendors that begins with the pay vendor that you enter in the Start field and ends with the last of all the available pay vendors. The End field is disabled for this option.
Start/End
Enter, or click to select, the starting pay vendor, ending pay vendor, or both for the range of pay vendors to be included in the process. Depending on your selection in Option, one or both of these fields may be inactive.
Pay Currencies
Option
Select the range of pay currencies to include. The options are:
-
All — Select this option to include all pay currencies. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one pay currency and enter that pay currency in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of pay currencies. Enter the beginning pay currency for the range in the Start field and enter the ending pay currency of the range in the End field.
-
From Beginning — Select this option to include a range of pay currencies that begins with the first of all the available pay currencies and ends with the pay currency that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of pay currencies that begins with the pay currency that you enter in the Start field and ends with the last of all the available pay currencies. The End field is disabled for this option.
Start/End
Enter, or click to select, the starting pay currency, ending pay currency, or both for the range of pay currencies to be included in the process. Depending on your selection in Option, one or both of these fields may be inactive.
Rate Group
Option
Select the range of rate groups to include. The options are:
-
All — Select this option to include all rate groups. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one rate group and enter that rate group in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of rate groups. Enter the beginning rate group for the range in the Start field and enter the ending rate group of the range in the End field.
-
From Beginning — Select this option to include a range of rate groups that begins with the first of all the available rate groups and ends with the rate group that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of rate groups that begins with the rate group that you enter in the Start field and ends with the last of all the available rate groups. The End field is disabled for this option.
Start/End
Enter, or click to select, the starting rate group, ending rate group, or both for the range of rate groups to be included in the process. Depending on your selection in Option, one or both of these fields may be inactive.
Options
Historical Rate Group
Override
Select this check box to override your current rate group and select another.
Rate Group
Enter, or click to select, the rate group identifier, or use Lookup to select the rate group.
Voucher Date Cutoff
Due Date
Select this option to compare the due date of all selected accounts payable vouchers with the date entered in As of Date. If you select this option, Costpoint updates the exchange rates of all open accounts payable vouchers with due dates before or on the date in As of Date.
Discount Date
Select this option to compare the discount date of all selected accounts payable vouchers with the date entered in As of Date. If you select this option, Costpoint updates the exchange rates of all open accounts payable vouchers with discount dates before or on the date in As of Date.
None
Select this option to update the exchange rates of all selected accounts payable vouchers.
As of Date
Enter, or click 
to select, or select the date to compare with accounts payable voucher due dates or discount dates.
Exchange Rate Date
Enter, or click to select, the exchange rate date in this field. The system will use this date to select the exchange rate to calculate any possible gains or losses.
Show Previous Rates
Select this check box if you want the system to print previous exchange rates. If you select this check box, you can examine the trend of the exchange rate.
Ignore vouchers with pay status
Select this check box if you want to continue updating the vouchers with new exchange rate even if vouchers have a status of pay exist.
Generate the Update Open A/P Exchange Rates Report
To generate the Update Open A/P Exchange Rates report before updating rates, click 
on the Costpoint toolbar, and click Update Open A/P Exchange Rates on the menu.
Update Open A/P Exchange Rates
To update open AP exchange rates, click the on the Costpoint toolbar, and click Update Open A/P Exchange Rates on the menu.
To generate the Update Open A/P Exchange Rates report at the same time as you update the rates, click Print/Update Open A/P Exchange Rates on the Action menu.