Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Exchange Rate was deleted
Finance | Project Operations, Human Resources, ...
Unanswered

Exchange Rate was deleted

(0) ShareShare
ReportReport
Posted on by Accounting Department 1,540

User cannot post payables cheques. In the Post payments window she selects the batch and right away gets this error.

pastedimage1614022162988v1.png

Background:

We have a new process that avoids econnect writing a 'bad rate' so the user enters the current month's rate with today's date.  However the user entered last months rate with a current month date, and after a week the rate was deleted instead of being modified.

We can't add the rate bac in.  This transaction doesn't even use the bad rate.  So not sure why it's even getting this error as everything looks good. 

I checked MC020103 and the trx is using the correct rate entry for this period.

How do we proceed?

(Note SY00500 had bchsttus of 110. I changed it to 0.  All this did was allow me to select the batch in Process Remittance, but I get the same error, just a diff window).

Categories:
Microsoft Dynamics GP
  • Accounting Department Profile Picture
    Accounting Department 1,540 on at
    RE: Exchange Rate was deleted

    We looked at MC020103 and it was apparent that there were multi-currency issues with the transactions in that batch.

    We updated sy00500 to set BCHSTTUS=0 for that batch.

    Now we can open the Batch in payables, print the edit list, and delete the Batch, and then the user re-entered the transactions.

    Posting Date to subledger is by Transaction, and to GL is by Batch.

  • Nicole Hellerud Profile Picture
    Nicole Hellerud 1,712 on at
    RE: Exchange Rate was deleted

    Hi Barb-

    Thank you for your update advising you are going to reach out to your Microsoft Partner for further support.

    One thought I wanted to chime in with is: checking how you the date is assigned when posting, is it by batch or by transaction?

    Administration >> Setup >> Posting >> Posting.

    Maybe there is some date mix up here causing the issue.

    I hope either this or the work with your Microsoft Partner get this squared away for you.

    When you do have a solution, I am sure we would all love feedback as to what ultimately resolved the issue.

    Best Regards,
    Nicole Fiskum
    Support Engineer
    Microsoft Dynamics GP

  • Accounting Department Profile Picture
    Accounting Department 1,540 on at
    RE: Exchange Rate was deleted

    This is good to know, unfortunately it did not resolve the issue.

    I updated MC020103 in the Test company for the two transactions that are blocked.

    I will log this with our partner.

    Thanks again.

  • Accounting Department Profile Picture
    Accounting Department 1,540 on at
    RE: Exchange Rate was deleted

    I ran Checklinks (in Test) but that didn't resolve.

    I cannot change the Rate Default as we have over 50 companies that share the exchange table and we use monthly rates.  

    I can log the issue with our partner.

  • Gavin Profile Picture
    Gavin 2,339 on at
    RE: Exchange Rate was deleted

    Hi,

    I've had similar issues in the past when rates have been removed or overwritten.

    I wrote about it in this blog http://thedynamicsexplorer.com/2019/08/14/dynamics-gp-error-this-transaction-contains-multi-currency-errors-and-cant-be-posted-when-posting-multi-currency-transactions/

    Although its not identical it might be worth reviewing to see if this can help at all.

    Thanks

    Gavin

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Exchange Rate was deleted

    Hello Barb,

    Based on the error message, the Exchange Rate doesn't exist for the date used on the Transaction. You will need to create the Exchange Rate that is needed. This can be added in the Exchange Table (Administration >> Setup >> System >> Exchange Table) for the Currency being used.

    You can also look at changing your settings for the Exchange Table to use Previous or Next Rate.

    pastedimage1614034149529v1.png

    You could also look at deleting the Check Batch and recreating it if you are certain the rate is valid. There could be something wrong in the table for the Exchange Table that we wont be able to see unless you open a support case to allow us to look at your setup and the transaction(s) in the batch.

    Lastly, you could try running check links on the Payables Transaction Logical to see if this corrects the issue. Please do not run this in live as we have no way of know what this will do. There is no way back unless you restore so please test in test.

    The information above is provided as is. I highly recommend you test in a test company with a copy of live.

    Thank you!

    Brandon Jarrett |Microsoft Support Engineer

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans