Setup Auto currency exchange rate (Currently not working)

ramielian · December 16, 2020, 2:40am

Hi all,

Is there a reason why the currency exchange rate is not working? is there anything need to be setup to be able to use it?

using :
ERPNext: v12.14.0 (version-12)
Frappe Framework: v12.12.0 (version-12)

kennethsequeira · December 16, 2020, 3:39am

From the documentation:

For foreign currency transactions, ERPNext checks exchange rates from:

From the Currency Exchange for any matching record (if created by a User).

If this fails, ERPNext will attempt to get the current market exchange rate from Frankfurter.

If this still fails, then the exchange rate will have to be entered manually.

So in your case, if the exchange rate wasn’t updated automatically from the API, you’ll need to create it manually. It is likely that the currency isn’t supported by Frankfurter yet.

ramielian · December 16, 2020, 4:12am

My currencies are USD and THB which are support by Frankfurter

And in the accounts settings " Allow Stale Exchange Rates" is enabled.

But the rates still don’t get updated.

Anyway to test if it is working or not? Manual trigger?

kennethsequeira · December 16, 2020, 6:14am

I just played around in my test setup and it was working:

No exchange rates set up manually. It was fetched from Frankfurter then.

Can you share more about your ERPNext setup? Is the system able to pull any other exchange rates?

zerodiscount · December 16, 2020, 3:50pm

Is it possible / confugurable to replace Frankfurter with a paid service that includes more currencies?

kennethsequeira · December 16, 2020, 4:28pm

Not configurable.

You’ll have to replace/override it from code:

github.com

frappe/erpnext/blob/3c77a4697b221674647860b7919867acdb55ea1a/erpnext/setup/utils.py#L101


      
          	if entries:
          		return flt(entries[0].exchange_rate)
          
          
	try:
          		cache = frappe.cache()
          		key = "currency_exchange_rate_{0}:{1}:{2}".format(transaction_date,from_currency, to_currency)
          		value = cache.get(key)
          
          
		if not value:
          			import requests
          			api_url = "https://frankfurter.app/{0}".format(transaction_date)
          			response = requests.get(api_url, params={
          				"base": from_currency,
          				"symbols": to_currency
          			})
          			# expire in 6 hours
          			response.raise_for_status()
          			value = response.json()["rates"][to_currency]
          
          
			cache.set_value(key, value, expires_in_sec=6 * 60 * 60)
          		return flt(value)

ramielian · December 17, 2020, 2:09am

Ok, It seems something wrong in my configurations, because my USD price does not update but any other price is getting fetched.