Acquisition: Currency exchange rates

[ManaDeweerdt]

User story

[TO COMPLETE]
For now,

• orderline: the 'amount' field doesn't display the currency of the vendor but the currency of the organisation.
• orderline: field 'exchange rate' not usable? --> what about the exchange rate encoded in the vendor resource?
• order: the vendor currency is displayed.
• Accounts: engagement not correct because it doesn't taken into account the currency. Ex: 12$ ordered >> 12€ engaged.

As a librarian, I want to know the currency exchange rates used in the acquisition, for orders/invoices, to get correct encumbrance in my accounts.

Acceptance criteria

RERO-ILS must know currency exchange rates, updated every day, in order to calculate encumbrance correctly.

Free External service can be use to collect "official" exchange rates like

European Central Bank : https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html
National Bank of Switzerland : https://www.snb.ch/fr/iabout/stat/statpub/zidea/id/current_interest_exchange_rates
The system can contact the external service, to get the new rates and store them into the database (+ index the rates)

Create a new table exchange_rates with the following columns:

date_currency rate : date
currency code (EUR, USD, CHF,…) : string
currency rate : float
The currencies rates are stored

In the acquisition, they are used by the system according to the default currency of the organisation.

Create a task in the scheduler to update the rates every morning (before 7am).

Screenshots/files

Tasks

[github-actions]

This issue is stale because it has been open 6 months with no activity.

[github-actions]

This issue is stale because it has been open 6 months with no activity.