Skip to Content
Menú
This question has been flagged
2 Respostes
5079 Vistes

When I try to add a made up VAT number to a Belgian contact in Odoo 15, there are two errors that I encounter. Note that the “Verify VAT Numbers” setting is disabled in the Accounting configuration.


The first scenario is when I add a contact and leave the country empty and try to add a VAT number:

The VAT number [BE0123456789] for partner [Fred Johnson] does not seem to be valid. 

Note: the expected format is 'CC##' (CC=Country Code, ##=VAT Number)


In the second scenario I add a country, in my case Belgium and try saving again. Now I get the following error:

The VAT number [BE0123456789] for partner [Fred Johnson] does not seem to be valid. 

Note: the expected format is BE0477472701


Why am I getting these errors?


Avatar
Descartar
Autor Best Answer

Belgian VAT numbers must follow a certain structure.


Belgian VAT numbers have 12 characters [BE + 10 digits]. The first number following the prefix is always "0". The last 2 digits constitute a control number.


The control number comes from the Modulus 97 test. The formula of this test is: 97 - (1st eight digits modulus 97)


Let’s take the example of Odoo, the VAT number is BE0477472701.


  • Take the first 8 digits: 04774727

  • Divide it by 97: 04774727 / 97 = 49223,9897

  • Take the result without the decimals and multiply it by 97: 49223 * 97 = 04774631

  • Calculate the difference: 04774727 - 4774631 = 96

  • 97 - 96 = 01 (last two digits of VAT number)

BE0477472701 → the test is passed!
Avatar
Descartar
Best Answer

1

Avatar
Descartar
Related Posts Respostes Vistes Activitat
1
d’abr. 25
7651
0
de març 25
1290
1
de març 25
30
0
de març 25
1147
3
de set. 24
5368