Contents of the Update Open Accounts Receivable Exchange Rates Screen

Use the fields and options to configure the Update Open Accounts Receivable Exchange Rates screen.

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, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
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 on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on 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 on 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

Field Description
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

Field Description
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

Field Description
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

Field Description
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

Field Description
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

Field Description
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

Field Description
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

Field Description
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 invoices with due dates before or on the date in As of Date, except invoices with a PAY status.

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 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.