Use this screen to load currency exchange rates into Costpoint Accounts Receivable. This ensures that the system will use the most current rates available when calculating gains and losses. If you do not use this screen before printing the 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 corresponding monies are collected.
Run this update before printing any customer statements, accounts receivable aging reports, or accounts receivable history reports; otherwise, out-of-date exchange rates may be used instead. This could result in an inaccurate recognition of gains or losses on foreign currency transactions.
You cannot update any A/R rates until you have successfully printed a report of these selections.
Enter 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. 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."
Select this checkbox to override your current rate group and select another.
Use Lookup to enter the rate group in this field. 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 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 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.
Enter the date to compare with invoice due dates or discount dates. The default is the system (today's) date.
Use this group box to select the accounts to be updated.
Select the range of accounts you want updated. 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 invoices you want updated. 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 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 invoices 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 customers you want updated. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter the starting customer for the customers 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 customer for the customers 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. 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 invoice currencies you want updated. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter the starting currency for the invoice 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 invoice 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. 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 Accounts Receivable 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 Receivable exchange rates.
Changes to this screen update the AR_HDR_HS table.