Import Exchange Rate (Automatic)

It is possible to automatically import a currency exchange rate in Moveware. To configure this, follow the steps below.

1. Navigate to Administration > Codes Management.

2. Add the Currency Import Type Combo Box (if missing).

3. Add a code record:

• code type = ‘Code’

• Code value = ‘Currency Import’

• Description = ‘Currency Impot’

4. Add the new currency import type code called ‘File’. This is used to specify the path of import:

• code type = ‘Currency Import’

• Code value = ‘File’

• Set Description as import file name with file path

Ex. C:\Temp\mwdocstest\CurrencyImport\Import MW Foreign Currency Exchange rates.csv

On the Import csv file, the import columns are as follows:

1. Base Currency*

2. Currency To*

3. Date*

4. Rate Debtors

5. Rate Creditors

6. Rate Report

7. Branch

• Mandatory fields

If no rate is specified in 4, 5, 6, it will be imported as 0. A blank line is required after the last record.

Additional setting:

• Comments can be set as a Backup file path:

Ex. C:\Temp\mwdocstest\CurrencyImport\backup\

After imported, the import file will be moved to this folder with the add date and time at the end of file name.

• If Extra field = Y, the backup file will be renamed with the date and time followed by the file name.

5. Set system parameter ‘AutoImportCurrency’ = Y

6. Put import file that have the same name in the same location that is set in Description in Step 2.

MoveConnect will auto import currency every 2 minutes.