Finance | Project Operations, Human Resources, ...

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

(1) Share

Report

Posted on by EL-29050242-0

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?

All responses (6)

Answers (0)

André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

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 40 on at

Like (0)

Report

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 15,039 Super User 2024 Season 2 on at

Like (0)

Report

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 Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

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 40 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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:

Solved: Dynamics AX 2012 - An exchange rate cannot be found for exchange rate type Default between currencies USD and EUR on exchange data .

Solved: Exchange rate type in expense report issue (dynamics.com)

Best regards,

Kevin