Skip to main content

Notifications

Announcements

No record found.

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

exchange rate issue during the credit note of project invoice.

(0) ShareShare
ReportReport
Posted on by 496
When posting a credit invoice in  where the accounting currency is CAD and the reporting currency is USD, we are getting errors because the reporting currency does not balance. I believe that the variance is due to the exchange rate at the time the original invoice was posted is different than the current exchange rate for the credit invoice.
 
 
 
Solution :
 
1) Credit note invoice date needs to use the same date of original invoice if Period is open.
 
2) To accommodate the variance, update the Maximum Penny Difference and Maximum Penny-Rounding in the Reporting Currency values. This allows the posting of the credit invoice.
 
Also, I tried with the AR parameter, but it is not working.
 
 
I tested above said parameter in Contoso also and found that there is no effect of this parameter if i set Yes or NO.
 
Set NO example.
 
Exchange rate 
 
original invoice
 
 
 
Credit note Today with different exchange rate.
 
 
As per the system, different exchange rates on the two different systems are supposed not to post the invoice but to post successfully.
 
I checked the voucher transaction, which took the same exchange as the original invoice date.
 
Set the Parameter as /YES,/ the same system behavior, so the parameter has no effect.
 
So in Contoso, it is working as expected but not in our environment.
 
Looking for a solution.
 
Is there any solution to this issue?
 
Thanks in Advance for any Help.
  • exchange rate issue during the credit note of project invoice.
    Thanks for the information
  • jvermette09 Profile Picture
    jvermette09 53 on at
    exchange rate issue during the credit note of project invoice.
    Hello,
     
    Were you ever able to find a better resolution to this issue? I am experiencing a similar issue but for a project adjustment.  It doesn't seem to happen often which makes it very difficult to identify the repro steps.
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    exchange rate issue during the credit note of project invoice.
    Hi,
    According to the error message, you can check this blog, which explains the possible reasons and solutions for this problem, you can refer to it:
    The error message "The transactions on voucher XXX do not balance as per [date]. (accounting currency: 50,00 - reporting currency: 50,00)" in open customer transactions settlement - Microsoft Dynamics 365 Blog
    Best Regards,
    Hana

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans