Controlling the Vendors VAT Registration Number format

Configuring Vendors
Video 6/7
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
An intermediate video requires some previous experience with Business Central, but it is still easily accessible to most people. Intermediate Videos with the tag "Commonly Used" describes the functionality that is used by most companies. Commonly Used

Playlists  Manage

Log in to create a playlist or see your existing playlists.

Open Playlist
Presenter: Jesper Nielsen, Head of Onboarding

How to control the Vendors VAT Registration Number format in Business Central?

In this video, I will go through the validation of the VAT registration number when you enter it in the field on the vendor.

This is what happens in the video

So here I have a Danish vendor and I will enter a VAT registration number and it returns to us an error because the VAT registration number does not meet the format that I have planned.

So what I need to do is I need to go to the country region code list.

And as it was a Danish vendor, I need to find Denmark and I find Denmark here. So under the navigate, the country region, I have the VAT registration number formats.

So in here, you can see the list of the valid formats that’s allowed in Denmark. So that would be DK and eight numbers, just eight numbers, DK and eight numbers in pairs of two, or just numbers in pairs of two.

So only these formats fulfill the requirement of the Danish government. If I don’t want any validation on the format on my VAT registration numbers, I just delete the values in this table.