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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Unrealized VAT with foreign currency

(1) ShareShare
ReportReport
Posted on by 424
Hello Experts,
We are using Unrealized VAT functionality in Business Central Cloud.
This functionality works great with local currency, but we have some problems when it comes to foreign currency transactions. 
For example, my local currency is PLN, I have Posted Purchase Invoice for 1000EUR Net and 230EUR VAT, with exchange rate of 4,5:


So with this exchange rate I have unrealized VAT calculated - 1035PLN.
When the payment is posted and settled with invoice, we have other exchange rate, because it is other day - in my example 6.0.
My accountant is expecting that when payment is posted, VAT will be posted (becasue we have unrealized VAT so the VAT is reposted between unrealized VAT and actual VAT account) with the new exchange rate, so not 1035PLN but 230EUR*6.0 = 1380PLN. But now I have VAT posted with the same amoutn, with excahnge rate 4.5:
 
Do you know if we can setup it differently, that when posting payment, system will use exchange rate from payment, not from invoice?

*My exchange rates are only examples ;) 

Thank you in advance! 
I have the same question (0)
  • Suggested answer
    Vinayak Vishnu Sagvekar Profile Picture
    212 on at
    Hi Friend,
     
    VAT amount never adjusted during the currency batch job run for forex fluctuation and it will adjusted for AR and AP in GLs not for VAT related transactions.
    Requesting your accountant to do the adjustment after payment posting through general journal to meet the expected result.
     
    For below your line
    system will use exchange rate from payment, not from invoice?
     
    Business Central does not natively support VAT recalculations based on the payment date's exchange rate without customization
     
    Regards,
    Vinayak Sagvekar

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans