Import Daily Exchange Rates
Use the Import Daily Exchange Rates screen to load currency exchange rates into Costpoint.
After downloading rates from an outside source (Wall Street Journal, Internet, and so on), use this utility to enter those rates into Costpoint without manually entering each rate. In addition to saving time, this utility helps you avoid entry errors.
Before running this utility, you must create an input file containing the exchange rates for the currencies in which your company conducts business. The input file must be either in text or comma-separated value (CSV) format. You can download exchange rates into your input file (from the Internet, for example) before loading them into Costpoint.
Run this utility before entering any multicurrency transactions to ensure that the most recent exchange rates are used.
There are two ways to work with input files in Costpoint:
- You can access the input file from the network by using Alternate File Locations.
- You can upload the input file to the Costpoint database; in which case, no further access to network folders is necessary.
If you decide to use the first option, click in the File Location field to select an alternate file location. If you choose the second option, leave the File Location field blank and use the File Upload Manager to upload the input file to the Costpoint database.
- Related Topics:
- Display the Import Daily Exchange Rates Screen
You access the Import Daily Exchange Rates screen from the Accounting domain. - Contents of the Import Daily Exchange Rates Screen
Use the fields and options to configure the Import Daily Exchange Rates screen. - Table Information for the Import Daily Exchange Rates Screen
Changes to the Import Daily Exchange Rates screen update the RT_BY_DT table.