Passa al contenuto
Menu
La domanda è stata contrassegnata
2 Risposte
5105 Visualizzazioni

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
Abbandona
Autore Risposta migliore

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
Abbandona
Risposta migliore

1

Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
1
apr 25
7752
0
mar 25
1313
1
mar 25
30
0
mar 25
1165
3
set 24
5703