Exchange rate does not exist

(0) Share

Report

Posted on by Carla Fowler

485

Hello,

We are using GP2010 and have a check batch that will not post. We are receiving the error message "The exchange rate does not exist." The exchange rate does exist for the time the invoice and check were created. I have also run check links on the system series - multicurrency access and multicurrency system setup tables and the financial series - multicurrency account master and multicurrency setup tables. No errors are appearing and the batch will still not post.

Thanks in advance for any suggestions.

Carla

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (0)

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Carla, have you checked the transactions in the batch to verify that they all have the correct currency assigned to them?

Was this reply helpful? Yes No
Carla Fowler 485 on at

Like (0)

Report

Hi Frank,

Yes, I have confirmed (there is only one check in the batch).

Thanks,

Carla

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

I have seen such a case and was related to the time stored at the exchange rate table. You may try to click on the "arrow" next to the currency field, and re-add the exchange rate. Then try to post the transaction.

Let us know how it goes,

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

How did you saved the transaction without valid exchange rate? I couldn't save the transaction without valid exchange rate.

Was this reply helpful? Yes No
Carla Fowler 485 on at

Like (0)

Report

Hi Mahmoud,

I have re-added the exchange rate...multiple times with varying date ranges. Still no luck.

Thanks,

Carla

Was this reply helpful? Yes No
Carla Fowler 485 on at

Like (0)

Report

Hi Soma,

The invoice and payment transactions have valid exchange rates. We may have removed the rate before we posted. However, we have now added back in and the check batch still will not post.

Thanks,

Carla

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

I would have one more suggestion, go to the Exchange rate table and check the "Transaction Date Default" option, is it set to the Exact date, previous date or next date.

Microsoft Dynamics GP > Tools > Setup > System > Exchange Table

Another thing, if you try to create a new check with the exact same criteria, would it accept it or the same error will pop up ?

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

Carla, thanks for the update.

Better delete and re-create the check and try to post the same.

Hope this helps!!!

Was this reply helpful? Yes No
Carla Fowler 485 on at

Like (0)

Report

Unfortunately we cannot void the payment because it is not posted. If we try to void the invoice we get a message that indicates that 'This document cannot be marked for voiding. It has been either partially applied or is on hold.' I don't know how else to the delete the check.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

If the check is not posted yet, then you can open this document in the appropriate transaction window and click delete button to remove the check.

Is the check belongs to AP or AR?

Was this reply helpful? Yes No