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

Notifications

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 133 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 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,577

#2
YUN ZHU Profile Picture

YUN ZHU 888 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 778 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans