
Hello Expert,
I would like to confirm whether the VAT calculation behavior described below is expected in Business Central, particularly for the Japan country .
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 |
Based on the above values, I expected the following rounding:
However, the Sales Order totals are calculated as:
This means the VAT amount is rounded down to 90, while the amount excluding VAT is rounded up to 910.
Is this behavior expected when VAT Amount Rounding Type = Down?
Or should the totals instead be calculated as:
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.