Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

An exchange rate cannot be found for exchange rate type closing between currencies

Posted on by 40
Hi,
When I try to upload General Journal entry via excel upload and posting, it shows error message as below symptom of showing difference between debit and credit balance on voucher and journal.
I checked but the balance is dead equal on excel, also the exchange rates are figured but does not work.
 
Any guru can help me with this?
 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,134 Super User 2024 Season 2 on at
    An exchange rate cannot be found for exchange rate type closing between currencies
    "what exact dates do you have exchange rates set and what dates are used in the source file?" >> On the Currency exchange rates, remove the From date filter and check for the first Start date for the conversion from KRW to USD. What is the transaction date for your posting? Is that date before the first start date?
     
    " for this journal the transaction currency?" >> You already mentioned that you are recording the transactions in Korean Won (KRW).
     
    Initially, it looks like there is an imbalance in the journal with one cent. Have you checked if the Excel amount values are rounded with two decimals (not just display, but really maximum 2 decimals)? Maybe the issue is due to some rounding issues. 
  • EL-29050242-0 Profile Picture
    EL-29050242-0 40 on at
    An exchange rate cannot be found for exchange rate type closing between currencies
    Hi, Thank you all.
    My Accounting Currency: Korean Won, Reporting Currency: US Dollar.
    I am recording transactions in Korean Won.
    Maximum penny difference and rounding in the reporting... is set as 0.01.
     
    Could you elaborate what below means so that I can respond more accurately?
    "what exact dates do you have exchange rates set and what dates are used in the source file?"
    " for this journal the transaction currency?"
    "automatic posting GL mapping to post this difference?"
  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,039 Super User 2024 Season 2 on at
    An exchange rate cannot be found for exchange rate type closing between currencies
    Hi,
     
    Did you try penny difference setup on GL parameters and also automatic posting GL mapping to post this difference?
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,134 Super User 2024 Season 2 on at
    An exchange rate cannot be found for exchange rate type closing between currencies
    Hi,
     
    For what exact dates do you have exchange rates set and what dates are used in the source file? What currencies do you have as an accounting currency, reporting currency, and for this journal the transaction currency?
  • EL-29050242-0 Profile Picture
    EL-29050242-0 40 on at
    An exchange rate cannot be found for exchange rate type closing between currencies
    Hi Kevin,
    Thank you for the response.
     
    I checked General Ledger > Ledger Setup > Ledger / then checked "Budget Exchange Rate Type" which was set as Budget.
    Changed to Default, did not work and saw that there was no exchange rate data configured for Default, so changed to Closing which is the only type has exchange rate configured for each date.
    But still no luck for solving my issues, I still have problems which the D365 is changing dates of my General Journal Line Entries to either Jan 1st of Jan 31st, along with discrepancies in voucher and journal's Debit and Credit Balance.
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    An exchange rate cannot be found for exchange rate type closing between currencies
    Hi,
    You can setup Exchange rate type for common postings and budgeting. General Ledger -> Setup -> Ledger had the option for "Default budget exchange rate type". Changing this to "Default" maybe can stop the error you received. Someone on the forum has had a problem similar to yours before and got a solution, you can refer to these old threads:
    Best regards,
    Kevin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans