UPDATE OPEN ACCOUNTS RECEIVABLE EXCHANGE RATES
Use Update Open Accounts Receivable Exchange Rates screen to load currency exchange rates into Costpoint Accounts Receivable. This ensures that Costpoint will use the most current rates when calculating gains and losses. If you do not use this screen before printing the Accounts Receivable Aging report, out-of-date exchange rates may be used. This screen is especially important when exchange rates fluctuate substantially between the time that invoices are issued and the time the corresponding payments are received.
Run this update process before printing any customer statements, accounts receivable aging reports, or accounts receivable history reports. If you do not, out-of-date exchange rates may be used. This could result in an inaccurate recognition of gains or losses on foreign currency transactions.
You cannot update any AR rates until you have generated the Update Open A/R Exchange Rates report based on your processing options.
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
Account
Option
Select the range of accounts to include. The options are:
-
All — Select this option to include all accounts. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one account and enter that account in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of accounts. Enter the beginning account for the range in the Start field and enter the ending account of the range in the End field.
-
From Beginning — Select this option to include a range of accounts that begins with the first of all the available accounts and ends with the account 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 that begins with the account that you enter in the Start field and ends with the last of all the available accounts. The End field is disabled for this option.
Start/End
Enter, or click 
to select, the starting account, ending account, or both for the range of accounts to be included in the process. Depending on your selection in Option, one or both of these fields may be inactive.
Invoice
Option
Select the range of invoices to include. The options are:
-
All — Select this option to include all invoices. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one invoice and enter that invoice in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of invoices. Enter the beginning invoice for the range in the Start field and enter the ending invoice of the range in the End field.
-
From Beginning — Select this option to include a range of invoices that begins with the first of all the available invoices and ends with the invoice 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 invoices that begins with the invoice that you enter in the Start field and ends with the last of all the available invoices. The End field is disabled for this option.
Start/End
Enter, or click to select, the starting invoice, ending invoice, or both for the range of invoices to be included in the process. Depending on your selection in Option, one or both of these fields may be inactive.
Customer
Option
Select the range of customers to include. Valid options are:
-
All — Select this option to include all customers. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one customer and enter that customer in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of customers. Enter the beginning customer for the range in the Start field and enter the ending customer of the range in the End field.
-
From Beginning — Select this option to include a range of customers that begins with the first of all the available customers and ends with the customer 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 customers that begins with the customer that you enter in the Start field and ends with the last of all the available customers. The End field is disabled for this option.
Start/End
Enter, or click to select, the starting customer, ending customer, or both for the range of customers 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.
Invoice Currency
Option
Select the range of invoice currencies to include. The options are:
-
All — Select this option to include all invoice currencies. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one invoice currency and enter that invoice currency in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of invoice currencies. Enter the beginning invoice currency for the range in the Start field and enter the ending invoice currency of the range in the End field.
-
From Beginning — Select this option to include a range of invoice currencies that begins with the first of all the available invoice currencies and ends with the invoice 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 invoice currencies that begins with the invoice currency that you enter in the Start field and ends with the last of all the available invoice currencies. The End field is disabled for this option.
Start/End
Enter, or click to select, the starting invoice currency, ending invoice currency, or both for the range of invoice 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.
Invoice Date Cutoff
Due Date
Select this option to compare the due date of all selected invoices with the date entered in As of Date. If you select this option, Costpoint updates the exchange rates of all unpaid invoices with due dates before or on the date in As of Date.
Invoice Date
Select this option to compare the invoice date of all selected invoices with the date entered in As of Date. If you select this option, Costpoint updates the exchange rates of all unpaid invoices with invoice dates before or on the date in As of Date.
None
Select this option to update the exchange rates of all selected invoices.
As of Date
Enter, or click 
to select, the date to compare with invoice due dates or invoice 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. If the rates are identical, the update report displays "No Change."
Generate the Update Open A/R Exchange Rates Report
To generate the Update Open A/R Exchange Rates report before updating rates, click the Print Default Report button on the Costpoint toolbar, and click A/R Exchange Rates on the menu.
Update Open A/P Exchange Rates
To update open AR exchange rates, click t
on the Costpoint toolbar, and click Update A/R Exchange Rates on the menu.
To generate the Update Open A/R Exchange Rates report at the same time as you update the rates, click and select Print/Update A/R Exchange Rates.