Create, copy and delete exchange rates

You can also create other folders and/or exchange rate tables to the "Origin type" folder. The "Origin type" folders define the object parameter "Origin type" of all containing folders and exchange rate tables. As master data admin, you can copy and paste exchange rates from one exchange rate table into another. You can also copy and paste exchange rates from and to Excel.

Folder/ Create Exchange Rate

  1. Right-click on a group of an origin type ► New ► Exchange rate table in the "Exchange rates" category.

    A new exchange rate table is created under the selected origin type.

  2. Change the default name in the "Name" entry field.
  3. Enter an ID in the "Key" entry field.
  4. Click Apply.

    The data are saved in Data Administration.

Create Exchange Rates

  1. Select and expand the "Exchange rates" category.

    The folders of the origin types and the default exchange rate table are displayed.

  2. Expand that origin type folder for whose exchange rate table you wish to create an exchange rate for.
  3. Switch to the "Calculation" tab.
  4. Click in the row with the star.

    A new exchange rate is created.

  5. In the from "From currency" column, select the source currency.
  6. In the "To currency" column, select the target currency you want to convert into.
  7. In the "Rate from" column, enter the exchange rate for converting from the source currency to the target currency.
  8. In the "Rate to" column, enter the exchange rate for converting from the target currency to the source currency.

    9. Alternative: Specify reciprocals

    1. Right-click on the "Rate to" column.

      The context menu opens.

      2. Exchange Rates, Calculation Tab, Context Menu

      Figure: Exchange Rates, Calculation Tab, Context Menu

    2. Click on Set Reciprocal of the other value.

      The value of the other relevant exchange rate is determined and entered.

  9. Enter a validity period for the exchange rate.
  10. Click Apply.

    The data are saved in Data Administration.

WARNING

The value in the "Rate to" column is not automatically determined after a change is made in the "Rate from" column.

Copy and Paste Exchange Rate

  1. Select and expand the "Exchange rates" category.

    The folders of the origin types and the default exchange rate table are displayed.

  2. Expand that origin type folder for whose exchange rate table you wish to create an exchange rate for.
  3. Switch to the "Calculation" tab.
  4. Select the exchange rate by clicking inside the last column on the left.

    The entire row is selected and can be copied.

    Press and hold CTRL to select multiple rows.

  5. Right-click on in the first row of the left column.

    The context menu opens.

    Alternative: Right-click in the highlighted area.

  6. Click Copy.
  7. Expand that origin type folder into whose exchange rate table you wish to paste an exchange rate.
  8. Switch to the "Calculation" tab.
  9. Right-click in the row with the star.

    The context menu opens.

  10. Click Paste.

    The selected and copied exchange rates are inserted.

  11. Click Apply.

    The data are saved in Data Administration.

Delete Exchange Rates

  1. Select and expand the "Exchange rates" category.

    The folders of the origin types and the default exchange rate table are displayed.

  2. Expand that origin type folder of whose exchange rate table you wish to delete an exchange rate from.
  3. Switch to the "Calculation" tab.
  4. Select the exchange rate by clicking inside the last column on the left.

    The entire row is selected and can be copied.

    Press and hold CTRL to select multiple rows.

  5. Right-click on in the first row of the left column.

    The context menu opens.

    Alternative: Right-click in the highlighted area.

  6. Click Delete.

    The selected exchange rates are deleted.

  7. Click Apply.

    The data are saved in Data Administration.