You can create and update exchange rates through a CSV file. For example, you can import the exchange rates you are using in your enterprise resource planning (ERP) system into Unifier so that the rates match in both systems.
You can import exchange rates with a CSV file by doing the following:
- Export a copy of the CSV file structure.
- Populate the CSV file with currency rate information.
- Import the CSV file into Unifier.
To export a copy of the CSV file structure
- Go to the Company Workspace tab and switch to Admin mode.
- In the left Navigator, click Standards & Libraries > Exchange Rates. The Exchange Rates log opens
- Choose File > Export. A confirmation window opens. You export the active exchange rates. Do one of the following:
- Click Open to open the file in Excel (or other editor that supports CSV files). You can save the file from here after previewing.
- Click Save to save the file to your local drive. Enter a name for the file and click Save.
To populate the CSV file with exchange rate information
- Open Microsoft® Excel (or other program compatible with the CSV format), and open the exported CSV file.
- Enter currency exchange rate information in the spreadsheet. The fields are discussed in the table below.
Notes:
- Do not delete or change the order of the columns.
- Successful import creates a currency exchange rate set with the Active status.
- Only the currency code is validated, but Unifier will add to the exchange rate set the values you specify in the CSV upload file.
- Only the absolute value for the exchange rate is considered. If you enter a negative value, the negative sign is dropped and only the value is considered.
- You can enter new rates, or update existing rates.
- Only the first five decimal values of the exchange rate are imported; if less than five decimal values are entered, zeros are added during the import to add up to five values.
- If you remove an exchange rate from the CSV file, the rate is retained in Unifier, and is not deleted.
- If there are errors in the CSV file Unifier will not import the CSV file.
- Save in CSV format.
In this column: | Do this: |
|---|---|
Currency Name | Enter the name of the currency. For example, United States Dollar. This currency name is not validated and is for reference only. |
Currency Code | Enter a valid currency code. Only the Currency Code is required and validated. |
1.0 Base Currency = | Enter the exchange rate for the currency. The number you enter rounds at ten decimal places. Enter numbers and decimal points only; do not enter special characters. |
To import the CSV file into Unifier
- Go to the Company Workspace tab and switch to Admin mode.
- In the left Navigator, click Standards & Libraries > Exchange Rates. The Exchange Rates log opens
- Choose File > Import to import the completed CSV file.
- Click Browse and navigate to where you saved the file.
- Click OK to import.
Only files with exchange rate information in the correct format will be imported. If the upload fails, the CSV file will contain an error message that explains why the upload failed. The user who imported the CSV file is listed in the Audit log as the User.
To fix import errors
- Re-open the CSV file.
- Delete rows that were successfully imported.
- Fix the rows that were not imported correctly.
- Re-import the file.
To export exchange rates to your desktop
- Go to the Company Workspace tab and switch to Admin mode.
- In the left Navigator, click Standards & Libraries > Exchange Rates. The Exchange Rates log opens
- Choose File > Export. A confirmation window opens. Do one of the following:
- Click Open to open the file in Excel (or other editor that supports CSV files). You can save the file from here after previewing.
- Click Save to save the file to your local drive. Enter a name for the file and click Save.