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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

VAT Amount Rounding Behavior for Prices Including VAT

(0) ShareShare
ReportReport
Posted on by 20 Microsoft Employee

Hello Expert,

I would like to confirm whether the VAT calculation behavior described below is expected in Business Central, particularly for the Japan country .

Scenario

  • Customer Card: Price Includes VAT = Enabled
  • Item Card: Prices are configured as Including VAT
  • VAT % = 10%
  • VAT Amount Rounding Type = Down

When a Sales Order is created and the item is added, the system calculates:

Field Value
Unit Price (Including VAT) 1,000
Quantity 1
Amount Excluding VAT (calculated) 909.09091

Expected Result

Based on the above values, I expected the following rounding:

  • Amount Excluding VAT = 909
  • VAT Amount = 91 (1,000 - 909)

Actual Result

However, the Sales Order totals are calculated as:

  • Amount Excluding VAT = 910
  • VAT Amount = 90

This means the VAT amount is rounded down to 90, while the amount excluding VAT is rounded up to 910.

Question

Is this behavior expected when VAT Amount Rounding Type = Down?

Or should the totals instead be calculated as:

  • Amount Excluding VAT = 909
  • VAT Amount = 91

I would appreciate clarification on how Business Central applies rounding in this scenario and whether this is the standard behavior for the Japan country.

Thank you.

I have the same question (0)

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April 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,273 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,669 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,402

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans