35
I created additional currencies - no problem.
I created an exchange rate service - floatrate.com. I can see the exchange rates for today, but I need it way back from 2000/01/01. How do I get the historical rates in as well?
If I now want to post a journal with a historical transaction in another exchange rate, I get this error:
There is no Currency Exchange Rate within the filter. Filters: Currency Code: USD, Starting Date: ''..07/15/20
Thank you. Done and dusted.
Thank you. I was hoping for an easier way, but a good old copy and paste did the trick.
I think KasparsSemjonovs is right here, for the old dates exchange rate we dont any kind of date filter while fetching the records, for that you can find the old exchange rate list and import directly into your BC table.
Exchange rate service only offers to input the daily currency exchange rates.
For historical exchange rates either a customization is needed, or as that is a one time job, You can create the needed info in Excel, and just copy/paste it in the currency exchange list, or import through configuration package.
If You will not be doing any re-calculation for the previous years, or have no open invoices/entries, You can just set an exchange rate with starting date 01.01.2000 and system will not give You errors. You need the rates to be correct for the time You started using the system (so starting form when opening balances were imported, or when first transactions were posted).
#1
André Arnaud de Cal...
293,041
Super User 2025 Season 1
#2
Martin Dráb
231,856
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
