跳至内容
菜单
此问题已终结
2 回复
5142 查看

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?


形象
丢弃
编写者 最佳答案

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!
形象
丢弃
最佳答案

1

形象
丢弃
相关帖文 回复 查看 活动
1
4月 25
7863
0
3月 25
1357
1
3月 25
30
0
3月 25
1192
3
9月 24
6068