Dynamics Community Forum Thread Details

Dutch VAT - Total of 5a not correct

Hi,
I am new in BC and try to complete the VAT report setup for the Dutch layout.
However I am not able to have the correct amount for the total 5a VAT to be paid in the report [5a Totaal verschuldigde BTW]
The issue I am facing is that the VAT amount for EU purchases are deducted from the total, where these should be added to the total. I tried a lot of variations with opposite sign and even added sub-totals. All without luck. Maybe I tried to much options, having me lost the overview.

I posted an sales invoice of 1.210 including 21% VAT (1a) = 210
I posted a NON EU purchase invoice 1.004,90 having 21% VAT exempt (4a + 5b) = 211,03
I posted a EU purchase invoice 1.000 having 21% VAT exempt (4b +5b) = 210

expected result at 5a = 210+211.03+210 = 631.03 (5a)
expected result at 5b = 211.03+210 = 421,03
Total VAT to be paid = 210 for this customer
In BC:
0243.1a.png
0456.4_2B00_5.png