Skip to main content

 

 

Coupa Success Portal

Exchange Rates Import

Overview

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* Exchange Rate TRUE FALSE decimal(30,9) any
Rate Date* Exchange Rate Effective Start Date TRUE TRUE datetime YYYY-MM-DDTHH:MM:SS+HH:MM
  • Was this article helpful?