Is there a way to create a method to obtain currency rates (Ex.: 1 USD = 28 NIO), from diferent sources like Yahoo Finances and from our national bank url?
So far what I’ve seen on the currency exchange form in Erpnext v7 is that I am able to just post one currency at a time, but It would be a good feature to have the option to fill up on a table the fluctuation currency per day and use the day’s currency for transactions.
I was looking for a way to modify the form but no success. I was thinking in having two options:
1 - Use not fluctuating currency:
From Currency = USD
To Currency = NIO
Rate (1 USD = ? NIO) = 28
System will use RATE, so there is not problem with regular operations.
2 Use fluctuating currency per day or month (if it change constantly):
From Currency = USD
To Currency = NIO
The system will use the actual RATE on the day of the working operations.
The other option would be to have a way to obtain the rate exchange from different sources, ex: Yahoo Finances, Google and from any country’s national bank.
Do you know if there is a way to accomplish such task easyly from ERPNEXT or by coding?
This makes a lot of sense. Could be implemented by creating an Exchange Rate doctype that can be maintained by Finance/Treasury user. Fields will be:
From Date - If this date is the most recent date before the posting date, then pick this line for the rate to apply
From Currency -
To Currency
Rate
Example Below:
Using the table above, if the posting date of a USD document in a company with company currency NGN is the 23/08/2016, the system will select the exchange rate of 280.
If this is of interest, I can push a pull request.
Sorry for long delay. I’ll be checking your pull and suggest comments if needed. Thanks
Update:
Great job, there are also some points to consider:
Import/Export from CVS format the exchange rate.
A basic window to show just the actual rate,currency rate and ToCurrency information. If customer need more info, click on that window and provide with the all the record as posted on pull.