This is what happens in the video
Business Central can validate the VAT registration number when you enter it on a vendor card. The validation checks the number against the allowed formats for the vendor’s country. If you enter a VAT registration number that does not match one of the approved formats for that country, Business Central returns an error and stops you from saving an invalid number.
You control the validation through the Country/Region Code list. For Denmark, the valid formats are DK followed by eight digits, eight digits on their own, DK followed by eight digits in pairs of two, or eight digits in pairs of two. Only these formats meet the Danish requirements.
If you do not want any format validation, you remove the formats from the VAT Registration No. Formats table for that country. With no formats defined, Business Central accepts any value in the field.
How VAT registration number validation works on the vendor card
When you fill in the VAT registration number on a vendor, Business Central checks the value against the format rules set up for that vendor’s country or region. If the number does not match an allowed format, you get an error message right away. This stops incorrectly formatted VAT numbers from entering your system in the first place.
As an example, if you have a Danish vendor and you type a VAT registration number that does not follow a Danish format, Business Central rejects it.
Where to find and edit the allowed VAT registration number formats
The allowed formats are defined per country. To see or change them, open the Country/Region Code list and find the country you need, for example Denmark. From the navigate menu on the country/region, open VAT Registration No. Formats. Here you see the list of valid formats allowed for that country.
For Denmark, the allowed formats are:
- DK followed by eight digits
- Eight digits with no prefix
- DK followed by eight digits in pairs of two
- Eight digits in pairs of two
These are the only formats that fulfil the Danish government’s requirements.
How to turn off VAT registration number validation
If you do not want any validation on the format of your VAT registration numbers, delete the values in the VAT Registration No. Formats table for the relevant country. Once the table is empty, Business Central no longer checks the format and accepts any value you enter.
Q&A
Why does Business Central reject my VAT registration number on a vendor?
Business Central validates the VAT registration number against the formats defined for the vendor’s country in the VAT Registration No. Formats table. If the number you enter does not match one of those formats, you get an error and cannot save it.
What are the valid VAT registration number formats for Denmark?
DK followed by eight digits, eight digits on their own, DK followed by eight digits in pairs of two, or eight digits in pairs of two. These are the only formats that meet the Danish requirements.
Where do I set up VAT registration number formats in Business Central?
Open the Country/Region Code list, select the country, and open VAT Registration No. Formats from the navigate menu on the country/region. There you can view, add, or edit the allowed formats.
How do I disable VAT registration number validation?
Delete the values in the VAT Registration No. Formats table for the country in question. With no formats defined, Business Central accepts any value in the field without checking the format.