Import Exchange Rates

This batch job makes it possible to import currency rates from the official national bank website for the specified period.

Required settings

Before running the batch job, check the following settings:

1. General Ledger Setup page, Import Exchange Rates tab:
   • Import Exchange Rates – this setting specifies whether currency rates are imported for the current company or for all existing ones in the system. When you import exchange rates using a job queue operation, the exchange rates are loaded by default for all companies in which this setting is activated;
   • Import Conflict Resolution – select one of the options – Replace, Skip, Prompt – for situations when the system has already identified currency rates;
   • Exchange rate start date formula - this setting specifies the date formula for the import start date in exchange rates.
2. Currency card, Import Exchange Rates field – enable this setting so that when a batch job is running, the rates of this currency are imported.

Running a batch job

To run the Import Exchange Rates batch job:

1. Choose the icon, enter Import Exchange Rates, and then choose the related link.

Alternatively, on the Currencies page, click Actions > Functions > Import Exchange Rates.

Note
When running a batch job from the Currencies list page, currency rates will be imported for the selected currency only.

2. In the request window, specify the dates of the period for which currency rates will be imported by filling out the Date From and Date to fields respectively.
3. If necessary, add the option One company, which, when activated, will import exchange rates only for the current company in the database.

After the batch job is completed, the imported currency rates can be checked:

• from the Currency list page in the Exchange Rate field;
• from the Currency list page or currency card by clicking Actions > Exch. Rates.

Configuring Scheduled Task for Currency Rates Import

The launch and execution of this periodic task can be configured using the Job Queue Entries. This allows for the automatic execution of the currency rates import at the specified intervals. Follow these steps to configure the job queue entry:

1. Click the button to open the Search function and enter Job Queue Entries, then select the relevant link.
2. On the Job Queue Entries list page, select and open the entry card corresponding to the Currency Rates Import task.
3. On the Recurring tab, configure the recurrence pattern for the task. For example, if you toggle the switches in the Run on Mondays, Run on Tuesdays, Run on Wednesdays, Run on Thursdays, Run on Fridays fields and specify a value in the Start Time field as 08:00, the task will be executed on the specified weekdays at 8:00 AM. Alternatively, you can specify a date formula in the Next Start Date Formula field. For example, using the DT4 value in this field will schedule the task to run every Thursday. For example, if you toggle the switches in the Run on Mondays, Run on Tuesdays, Run on Wednesdays, Run on Thursdays, Run on Fridays fields and specify a value in the Start Time field as 08:00, the task will be executed on the specified weekdays at 8:00 AM. Alternatively, you can specify a date formula in the Next Start Date Formula field. For example, using the DT4 value in this field will schedule the task to run every Thursday.
4. On the Job Queue tab, enable the Report Request Page option to invoke the report request page, where can be choosen to import currency rates for one company or for all existing ones in the system.
5. Click Process > Set Status to Ready.

Note
It should be taken into account that for the correct fulfilling of the batch job of importing currency rates for all existing companies, it is not recommended to launch in the foreground - from the Run once (foreground) button.

See Also

Currency
Exchange Rate Adjustment