Use this screen to load currency exchange rates into Costpoint Accounts Payable. This ensures that the system 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 screen before selecting vouchers for payment and before computing unrealized gains and losses.
Enter the date on which you want the system to select the exchange rate to calculate any possible gains or losses.
Select this checkbox if you want the system to print previous exchange rates. By doing this, you can examine the trend of the exchange rate.
Select this checkbox to override your current rate group and select another.
Use Lookup to enter the rate group. This rate group was originally created in the Maintain Exchange Rate Groups screen.
Select this radio button to compare the due date of all selected Accounts Payable vouchers with the As of Date entered in the field to the right. Costpoint will update the exchange rates of all open Accounts Payable vouchers with due dates before and the same as the selected As of Date.
Select this radio button to compare the discount date of all selected Accounts Payable vouchers with the As of Date entered in the field to the right. Costpoint will update the exchange rates of all open Accounts Payable vouchers with discount dates before and equal to the selected As of Date.
Select this radio button to update the exchange rates of all selected Accounts Payable vouchers.
Enter the date to compare with Accounts Payable voucher due dates or discount dates.
Use the drop-down box to select either by "Cash Account," "AP Account," or "Bank Abbreviation."
Select the range of accounts you want updated by open Accounts Payable exchange rates. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter the starting account for the accounts you want included in this update. If you select "All" or "From Beginning" in the Range Option field, this field will be unavailable.
Enter the ending account for the accounts you want included in this update. If you select "All," "One," or "To End" in the Range Option field, this field will be unavailable.
Select the range of vouchers you want updated by open Accounts Payable exchange rates. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter the starting number for the vouchers you want included in this update. If you select "All" or "From Beginning" in the Range Option field, this field will be unavailable.
Enter the ending number for the vouchers you want included in this update. If you select "All," "One," or "To End" in the Range Option field, this field will be unavailable.
Select the range of pay vendors you want updated by open Accounts Payable exchange rates. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter the starting vendor for the pay vendors you want included in this update. If you select "All" or "From Beginning" in the Range Option field, this field will be unavailable.
Enter the ending vendor for the pay vendors you want included in this update. If you select "All," "One," or "To End" in the Range Option field, this field will be unavailable.
Select the range of organizations you want updated by open Accounts Payable exchange rates. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter the starting organization for the organizations you want included in this update. If you select "All" or "From Beginning" in the Range Option field, this field will be unavailable.
Enter the ending organization for the organizations you want included in this update. If you select "All," "One," or "To End" in the Range Option field, this field will be unavailable.
Select the range of pay currencies you want updated by open Accounts Payable exchange rates. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter the starting currency for the pay currencies you want included in this update. If you select "All" or "From Beginning" in the Range Option field, this field will be unavailable.
Enter the ending currency for the pay currencies you want included in this update. If you select "All," "One," or "To End" in the Range Option field, this field will be unavailable.
Select the range of rate groups you want updated by open Accounts Payable exchange rates. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter the starting rate group for the rate groups you want included in this update. If you select "All" or "From Beginning" in the Range Option field, this field will be unavailable.
Enter the ending rate group for the rate groups you want included in this update. If you select "All," "One," or "To End" in the Range Option field, this field will be unavailable.
Select this button on the toolbar to update open A/P exchange rates. This button is not available until you print the report.
Select this button on the toolbar to print the report and update the open Accounts Payable exchange rates.
Changes to this screen update the OPEN_AP table.