Use this screen to load currency exchange rates into Accounts Receivable. This ensures that the system will use the most current rates available when calculating gains and losses.
This screen is especially important when exchange rates fluctuate substantially between the time that you issue invoices and the time that you collect the corresponding monies.
Run this update before printing any customer statements, accounts receivable aging reports, or accounts receivable history reports. If you do not use this screen before printing the aging report, the system may use out-of-date exchange rates. This could result in inaccurate recognition of gains or losses on foreign currency transactions.
You cannot update A/R rates until you have successfully printed a report of these selections.
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. Once 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. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should 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 produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Use the drop-down box to select the range of accounts you want to update. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter, or use Lookup to select, the starting account for the accounts you want to include in this update. If you select "All" or "From Beginning" in the Option field, this field will be unavailable.
Enter, or use Lookup to select, the ending account for the accounts you want to include in this update. If you select "All," "One," or "To End" in the Option field, this field will be unavailable.
Use the drop-down box to select the range of invoices you want to update. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter the starting number for the invoices you want to include in this update. If you select "All" or "From Beginning" in the Option field, this field will be unavailable.
Enter the ending number for the invoices you want to include in this update. If you select "All," "One," or "To End" in the Option field, this field will be unavailable.
Use the drop-down box to select the range of customers you want to update. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter, or use Lookup to select, the starting customer for the customers you want to include in this update. If you select "All" or "From Beginning" in the Option field, this field will be unavailable.
Enter, or use Lookup to select, the ending customer for the customers you want to include in this update. If you select "All," "One," or "To End" in the Option field, this field will be unavailable.
Use the drop-down box to select the range of organizations you want to update. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter, or use Lookup to select, the starting organization for the organizations you want to include in this update. If you select "All" or "From Beginning" in the Option field, this field will be unavailable.
Enter, or use Lookup to select, the ending organization for the organizations you want to include in this update. If you select "All," "One," or "To End" in the Option field, this field will be unavailable.
Use the drop-down box to select the range of invoice currencies you want to update. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter, or use Lookup to select, the starting currency for the invoice currencies you want to include in this update. If you select "All" or "From Beginning" in the Option field, this field will be unavailable.
Enter, or use Lookup to select, the ending currency for the invoice currencies you want to include in this update. If you select "All," "One," or "To End" in the Option field, this field will be unavailable.
Use the drop-down box to select the range of rate groups you want to update. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter, or use Lookup to select, the starting rate group for the rate groups you want to include in this update. If you select "All" or "From Beginning" in the Option field, this field will be unavailable.
Enter, or use Lookup to select, the ending rate group for the rate groups you want to include in this update. If you select "All," "One," or "To End" in the Option field, this field will be unavailable.
Use the fields in this block to tailor the appearance of your report.
Select this checkbox to override your current rate group and select another.
Use Lookup to enter the rate group in this field.
You originally created this rate group in the Maintain Exchange Rate Groups screen.
Select this radio button to compare the due date of all selected invoices with the As of Date entered in the field to the right.
Costpoint will update the exchange rates of all unpaid invoices with due dates before and the same as the selected one in the As of Date field.
Select this radio button to compare the invoice date of all selected Accounts Receivable vouchers with the As of Date entered in the field to the right.
Costpoint will update the exchange rates of all unpaid invoices with invoice dates before and equal to the selected As of Date.
Select this radio button to update the exchange rates of all selected invoices.
Use Calendar Lookup or enter a date. The default is the system (today's) date.
Use Calendar Lookup or enter the exchange rate date in this field.
The system uses this date to select the exchange rate that will be used to calculate any possible gains or losses. The default for this field is the system (today's) date.
Select this checkbox if you want the system to print the previous and updated exchange rates.
By doing this, you can examine the trend of the exchange rate. If the rates are identical, this update report will show "No Change."
* A red asterisk denotes a required field.
Select this button on the toolbar to update open Accounts Receivable exchange rates. This button is not available until you print the report.
Print/Update A/R Exchange Rates
Select this button on the toolbar to print the report and update the open Accounts Receivable exchange rates.
Changes to this screen update the AR_HDR_HS (AR Header History) table.