Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Foreign Currency Reval...
Microsoft Dynamics AX (Archived)

Foreign Currency Revaluation for Vendors

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

We have successfully done with Foreign Currency Revaluation for Vendors as of December 31, 2018.

After the revaluation, while checking the vendor balances (as illustrated in the first picture), it is showing correctly as per the new currency exchange rate while as when running the reports such as 'vendor balances by posting profile' or 'vendor balance list' still showing as per the exchange rate before the revaluation (as illustrated in the second picture). Also noticed that it is not matching the GL and Sub GL after the revaluation.

25266.Untitled.png7026.Untitled1.png

If anybody can help, it will be a great help to us.

Regards,

Unais

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Foreign Currency Revaluation for Vendors

    Hello Unais,

    What you can do is running the GL - Vendor reconciliation report that is available in GL.

    This report can show you the variances that exist between GL and AP and highlight the transactions that are responsible for those differences.

    Can you run this report and share us the details?

    Many thanks,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Foreign Currency Revaluation for Vendors

    Hi Mr. Reinhard,

    Any uodate from your end.

    Regards,

    Unais

  • guk1964 Profile Picture
    guk1964 10,877 on at
    RE: Foreign Currency Revaluation for Vendors

    https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/view-the-transactions-of-a-foreign-currency-revaluation

    That report may give you some insights.

    Its also useful to run this report as part of your revaluation process. https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/vendor-foreign-currency-revaluation-report-vendexchrateadjustment

    Also see this former thread post https://community.dynamics.com/ax/f/33/t/238269 which explains why you may get report differences.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Foreign Currency Revaluation for Vendors

    I do understand t that the 'vendor balances by posting profile' is a customized report, but vendor 'balance list' also reflecting the same. I dont think that the 'vendor balance list' is a customized report but it is a standard report.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Foreign Currency Revaluation for Vendors

    Hello Unais,

    The report that you shared is a customized one.

    The problem might be related to the report design and the data shown in the report.

    Can you check with the developer who created this report for you?

    Many thanks,

    Ludwig

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans