Foreign Currency fluctuation

Frappe Framework Custom Script
1

Sir is the forex currency fluctuation done automatically in ERPnext.

2

Yes, we get latest currency changes from fixer.io

3

Thanks sir Can you shoe me some working.

4

@Hap_Dorji

If you need code to get latest currency exchange rate, then here is example

>>> import requests

>>> response = requests.get("http://api.fixer.io/latest", params={

...     "base": "USD",

...     "symbols": "INR"

... })

>>> value = response.json()

>>> print value

{u'date': u'2016-06-22', u'base': u'USD', u'rates': {u'INR': 67.496}}

>>>
5

@Hap_Dorji how about history of the exchange rate? Say, I made a purchase a week ago in EUR and I want to sell it now in TRY and I’d like to know what the buy price in TRY was. Surely the exchange rate is not the same as it was a week ago.
How is this handled?

6

@bicli history if exchange rate is not stored.
However you can create report for exchange rate history from submitted Sales/Purchase Invoices.

7

@kolate_sambhaji would you mind giving me a hint about how I could do that?

8

@bicli you need to write query report for currency rate.
You can fet details of exchange rate, currency from Sales and Purchase invoice.

https://frappe.github.io/erpnext/user/manual/en/customize-erpnext/articles/making-custom-reports-in-erpnext.html