web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Currency revaluation a...
Small and medium business | Business Central, N...
Suggested Answer

Currency revaluation and Vat

(0) ShareShare
ReportReport
Posted on by CandiceJack 13

Hi,

When I adjust the currency exchange rates at the end of the month, the revaluation is adding in Vat.  This is impacting my Vat Declaration of Sales and purchases and also causing an imbalance on the Debtor and Creditor ledger to the reports.  How do I turn do I make sure that the system doesn't automatically include vat on currency adjustments.

Thanks  

Candice

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 150 on at

    Looks to be a setup issue upon review of the report code.

    GLSetup."VAT Exchange Rate Adjustment" = GLSetup."VAT Exchange Rate Adjustment"::"No Adjustment")

                   then

                       CurrReport.Break;

    Go to the general ledger setup and ensure you have the field "VAT Exchange Rate Ajustment" as "No Adjustment"

  • CandiceJack Profile Picture
    CandiceJack 13 on at

    Hi Josh,  

    Thank you for your reponse.

    I have been to the GL Setup the only place the Vat Exchange Rate adjustment appears is under GL setup - reporting.  This is set to no adjustment previously and is posting incorrectly.

    pastedimage1595970417742v1.png

    Posting Date Document No. Document Type Base Amount VAT Calculation Type Type Bill-to/Pay-to No. External Document No. Entry No.
    30/04/2020 REVALUE_300420   47.21 9.44 Normal VAT Sale 5461
    30/04/2020 REVALUE_300420   -208.51 -41.7 Normal VAT Purchase 5462
    30/04/2020 REVALUE_300420   161.3 32.26 Normal VAT Purchase 5463
    30/04/2020 REVALUE_300420   -1,270.16 -254.03 Normal VAT Sale 5464
    30/04/2020 REVALUE_300420   271.35 54.27 Normal VAT Purchase 5465
    30/04/2020 REVALUE_300420   998.81 199.76 Normal VAT Purchase 5466
  • Suggested answer
    Dirk Profile Picture
    Dirk Microsoft Employee on at

    Hi Candice,

    Please check the gen. posting type and the posting groups (Gen. & VAT) on the G/L Account for the currency adjustments (gains / losses).

    These should be blank.

    If the issue perists ... please log a service request at Microsoft.

    If you are from a partner you can do this yourself.

    If you are from a customer please contact a partner and he will report this issue for you.

    Thanks

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,850 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,084 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans