Validation of tax exempt number

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

i am not sure if it is possible in D365fO to use the validation-option of the tax exempt number in order to get the "right" tax exempt number including the prefix.

In other words: For example in germany the right constellation of the tax exempt number is "DE" + 9 numbers. If i set the validation, D365fO checks if there are 9 numbers. That is correct and ok. But it is not allowed to put the prefix "DE" in here.

2017_2D00_02_2D00_24-11_5F00_43_5F00_22_2D00_Tax-exempt-numbers-_2D002D00_-Operations.png

So i have to remove the "DE" and then i can save the tax exempt number.

2017_2D00_02_2D00_24-11_5F00_44_5F00_25_2D00_Tax-exempt-numbers-_2D002D00_-Operations.png

But now the tax examt number is shown without the prefix and that is what i am wondering about.

2017_2D00_02_2D00_24-11_5F00_45_5F00_50_2D00_All-customers-_2D002D00_-Operations.png

Now my question is: Is there a possibility to add the correct prefix there and additonally use the validation-option?

Best regards

Christian

*This post is locked for comments

All responses (11)

Answers (0)

André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

RE: Validation of tax exempt number

Hi Veronika,

There is a list on the internet: en.wikipedia.org/.../VAT_identification_number

For some country/regions the validation is added as part of the localization, but not for all countries.
Veronika Filonenko 1,255 on at

Like (0)

Report

RE: Validation of tax exempt number

Where are the rules against which the format of vat numbers are being validated per country?

Is this hard coded?

How can I know what number of digits is it actually validating for each country?
Alexander.Dobinson 140 on at

Like (0)

Report

RE: Validation of tax exempt number

The validation is on the format of the number not including the DE prefix.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Validation of tax exempt number

Hi Christian,

I would suggest that you either implement a system modification and/or inform the MS team via MS connect if the standard functionality does not meet your expectations.

Best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: Validation of tax exempt number

Hi Ludwig,

I know about the fact, that there is no check for the correct number and that it is only a check about the format. But even this "format-check" is not working right if you cant put the prefix "DE" in there.

So in my opinion this check here is totally useless like it works right now.

Best regards,

Christian
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Validation of tax exempt number

Hi Christian,

In this case I would suggest that you remove the validation parameter. That is because the 'validation' is not a real validation in the sense that the tax exempt number really exists. It's a mere check whether the number format and the control digits are ok but there is no guarantee that this number really exists. A correct validation requires a link to an external data provider who can do that check for you but this is not available in the standard application and requires a system modification.

Best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: Validation of tax exempt number

Hi Ludwig,

yes if i remove it, I can put in nearly everything I want for the tax examt number. But then no Validation will be made and that is not what i want :)

In my opinion, the Validation should work for a number like "DE123456789". But i only can put in the "123456789" number without the prefix "DE".

Best regards

Christian
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Validation of tax exempt number

Hi Christian,

If you remove the Parameter 'Umsatzsteuernummer überprüfen' can you enter the tax id number with the DE prefix?

Best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: Validation of tax exempt number

Hello Ann,

hello Ludwig,

thanks for your answers. I did check the paramters there and i allready changed them, but everytime i want to enter a new tax examt number, i get the same message " It is not allowed to enter letters here"

I just removed the "DE" here, but this did not work, too.

So i dont know what to to right now.

Best regards

Christian
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: Validation of tax exempt number

Hi Christian,

Please have a look at what AnnGrev suggested and enter the complete number including the prefix in the tax exempt number field. The parameter settings will then ensure that AX can identify the number and country.

Best regards,

Ludwig