VAT verification method

boby

Hello,

I'm asked to verify the VAT registration number of new customers, I know that thes numbers are "intelligent" (control included, such as modulo 97.. ) but I don't know which verification formula must be applied according to the country initials....

Has someone encountered this issue? Resolved?

Thanks

ngebhard

I found a link where you can get the format:
http://www.bzst.de/ust/useg/usegid.html

Using the navision help (if you're in the form "VAT Registration No. Formats") and this document should to get the verification formula to every country code.


Regards
Nicole

boby

Thanks Nicole,
I'll practice my german courses

But if I understand this info, it's about the structure of the number..
It's a part of my problem (thank you anyway for your help), because I need to apply a logical test too (like on VISA card and modulo 97)

Each country has his test I think

ngebhard

Sorry, but I don't know an English link!

You are right, that this is about the structure. But is the navision test not enough for you? I mean: if you type DE######### for German customers, no one can enter somethink like ER123CFSEDD as the VAT registration no. I don't understand what kind of logical test you want to implement. Sorry, but maybe I'm already in the weekend !!! ](*,)

Greetz
Nicole

boby

Sorry, my question is not well explained.
When I say that I 'd like to know the logical test on these numbers, I mean that they contain a verification in their structure..

For example, the two last numbers of a belgian VAT number are the number remaining after the division of the number formed by the 7 first figures by 97.. The VAT number is "intelligent" because it tests itself and you can avoid typing errors

It's the same with VISA numbers (AKA modulo97)

Marije_Brummel

From http://www.visualbasic.be/tip.asp?tipid=108 (Thanks Google)

Controle voor een Belgische BTW-nummer:

Private Function ControleBtwNummer(BtwNummer As String) As Boolean

ControleBtwNummer = IIf(((97 - Val(Left(BtwNummer, 7)) Mod 97)) = Val(Right(BtwNummer, 2)), True, False)

End Function

Convert to C/AL, Hope this helps.

boby

Thank you very much..
That's exactly what I'm looking for!! =D>

But our company works a lot with the other EU countries, this test won't work with other countries' VAT numbers #-o

Marije_Brummel

You have to find this function for all countries then

www.google.com

Succes.

HalMdy

In Belgium, we have a localized CU 11300 that contains the formula in a function to check the VAT number .

I suppose it will exist the same type of code for other countries... Could you give a list of countries you want ?

boby

In fact, I'm looking for EU countries, but the most important countries for us are Holland, Germany and France (as most belgian factories I think).

Thank you

Marije_Brummel

Have you looked at this site?

http://europa.eu.int/comm/taxation_cust ... eshome.htm

I don't know if every country has a checksum in its VAT number.

boby

I didn't know this site.

Thank for the advice!!

enoahmedspahic

How to use VAT NO templates...I know for "VAT Registration No. Formats" table and for using chars ?, # ... but I have problem with selecting country code. I can acces to list of countrys and select one but it doesn't use selected value in coresponding field.

jannestig

aren't the VAT no formats already provided in the world wide Version

under the countries region setip

Application admin> General Country Regions > select the VAT registration and the format exists usually though it might only be shown in indivisual country versions.

It is my understanding then that the customer/vendor VAT registration number is then checked against this.

I did a test in cronus and an error message is generated when the format is not correct.

enoahmedspahic

I change in VAT Registration No. Format table in "Country Code" field property "Editable" to "yes" and now it work fine. In my Company template for VAT No. table was empty until now. Now i make two templates for two entities in my country. Also you can create other templates based on other special characters(see help for table).