The Exchange Rate Import process read files from
./Incoming/ExchangeRates/ in the SFTP. These files will be moved to the archive folder located at
./Incoming/Archive/ExchangeRates/ before being processed in alphanumeric order.
Coupa does not support modifying existing exchange rates, only creating new rates.
The Exchange Rates loader only supports the creation of one-way exchange rates. For example, if you include for EUR > USD in the loader, you'll have that rate populated in your Coupa instance, but the reverse rate (USD > EUR) won't be created. You need to explicitly include USD > EUR for it to be included.
Exchange Rate Columns
|Column Name||Description||Req'd||Unique||Type||Allowable Values|
|From Currency*||The source (base) currency code.||TRUE||FALSE||string(6)||Currency code must exist in Coupa|
|To Currency*||The target currency code.||TRUE||FALSE||string(6)||Currency code must exist in Coupa|
|Rate Date*||Exchange Rate Effective Start Date||TRUE||TRUE||datetime||YYYY-MM-DDTHH:MM:SS+HH:MM|