Validation of tax exempt number

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (11)

Answers (0)

AnnGrev on at

Like (1)

Report

Have you checked:

Tax/

Setup/

Sales tax/

Country/region parameters

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Christian,

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

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Alexander.Dobinson 140 on at

Like (0)

Report

The validation is on the format of the number not including the DE prefix.

Was this reply helpful? Yes No
Veronika Filonenko 1,261 on at

Like (0)

Report

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?

Was this reply helpful? Yes No