Vendor Foreign Currency Revaluation Error - Difference between local and foreign currency balance. How reverse or cancel or delete related records?

(0) Share

Report

Posted on by Community Member

Hi, dear colleagues!

We have issue with foreign currency revaluation for vendor.

There are a lot of records related to revaluation, but, final balance is not correct as you can see at screenshot below.

1 - there was a fully settled invoice from year-2014
2 - in 2016, why, when calculating the exchange rate difference, the amount is calculated on it. The amount is visible in the unrealized exchange rate difference

3 - between the balance of vendtransopen and vendtrans there is a difference of 278,000 (the balance does not show the amount, the turnover sheet shows)
4 - Reversed settlement postings on this invoice for 31.12.2017 and re-calculated (settled) on a new date, compared open invoices, set the revalution of the exchange rate difference - the difference between the amounts of tables on the contrary increased
5- there are currently no open transactions;

6-Vendors's foreign currency balance 0 - Local currency balance 0, amount by vendtrans - 2935465,97 (local currency)

How we can manually (x++) reverse (cancel or delete) this revaluation records (vendsettlement, generaljournalentry, generaljournalaccountentry) and recalculate currency revalution?

Thanks in advance!

Screen-Shot-2018_2D00_02_2D00_25-at-01.18.26.png

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report
Copy link

Link copied!

you can check this work around

community.dynamics.com/.../121380

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sarvan,

Do you know how it comes?

Did you solve this issue yet? Currently I am also in the same situation when I performed AP revaluation and Vendor settlement. The Accounting amount is multiple while the transaction currency is correct.

Hope to hear from you and others.

Thanks

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Thi Thi,

Is this question related to the other reply that you send before?

Is it the same issue or something different?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Ludwig,

Yes, it's the one QA. I am facing with the issue of vendor settlement and exchange rate adjustment. Some how the adjustment amount occurred incorrectly, it made the accounting currency balance quite strange (much bigger than normal).

I will create new thread to present my issue, hope to have your advice on that.

Thank you!

Was this reply helpful? Yes No