Skip to main content
Mappings information
Search
Search Indirect Tax Support Help and Support.

This article applies to:

  • Product: ONESOURCE Indirect Tax,ONESOURCE Indirect Tax Compliance

Exchange Rate Mapping

The purpose of Exchange Rate map is to apply exchange rates to the transaction amounts in the source file upon allocation.
Exchange rate maps apply exchange rates configured in Indirect Tax Compliance to transaction amounts in your source file upon allocation.

Currency exchange rates from source file

Exchange rates can be pulled into Indirect Tax Compliance from source files if rates are present in the ERP system. Users do not have to create a source exchange rate or configure the exchange rates for different dates if using this method.
With this option, users can import exchange rates into OIC with their regular data import. Data for ‘Transaction Exchange Rate’ must be present in the import file along with ‘Transaction currency’ and ‘Currency’ values. These fields need to be mapped in import specification to ‘TransactionExRate’, ‘TransactionCurrency’ & ‘Currency’ fields respectively.
You must configure the ‘Exchange Rate Map’ to a source file for the relevant entities.
To work with exchange rates, select
Configuration
>
Exchange Rates
 from the menu.

Adding an Exchange Rate Source

  1. To add a new source, select
    Add Source
     on the toolbar.
  2. On the window that opens, define a name for the source in the
    Name
    field.
  3. Use the Frequency dropdown to indicate the frequency (Daily or Monthly).
  4. Select OK.
  5. Use the
    Exchange Rate Sources
     dropdown to find the source you created.
  1. Use the Calendar in the
    Date
    field to define the date for this source.
  2. Select anywhere in the
    Currency From
     field and select the source currency that the exchange rates are being mapped from.
  3. Select anywhere in the
    Currency To
     field and select the target currency that the exchange rates are being mapped to.
  4. In the
    Value
    field, enter the value for this exchange rate.

Deleting an Exchange Rate Source

To delete an exchange rate mapping source, select
Delete Source
 on the toolbar. A new window opens that lets you find the mapping source you want to delete.
  1. Select the indicator in the
    Exchange Rate Source
     field.
  2. Type a phrase in the Search box to identify the source to delete.
  3. Select
    Apply
    .
  4. Check Delete next to the source you want to delete.
  5. Select
    OK
    to confirm the deletion.