ADempiere 3.4 ERP Solutions

Importing currency rates

When working with multiple currencies, we need to set up exchange rates, for example, IDR against USD. With our existing configuration, we will try to import currency rates for the Daily currency type.

Creating the Daily currency rates Import Loader Format

In the Import Loader Format window, we'll add and save the following information on the Import Format tab:

1. Set the Organization field to *.
2. Set the Name field to Import Daily currency rates.
3. Set the Table field to I_Conversion_Rate (shown as I_Conversion_Rate_Import Conversion Rate in the option).
4. Set the Format field to Comma Separated.

Next, we'll proceed to the Format Field tab. The I_Conversion_Rate table contains 21 columns that can be used to construct an import structure. ...