Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

How to list all partners with wrong VAT number?

By
Jairo Llopis
on 12/26/13, 9:02 AM 1,791 views

After installing the base_vat module, I get these VAT validation errors when importing partners from other sources:

warning -- ValidateError Ha ocurrido un error mientras se validaban los campo(s) vat: El CIF/NIF no es válido. El formato esperado es ESA12345674

Which means:

Error validating VAT field: Wrong VAT. Expected format is ESA12345674.

But there is no clue about which record caused the error. How to know it? Better yet: how to know every wrong VAT record in the CSV or in OpenERP's database?

Workaround:

I found that I can remove the base_vat module before importing, and install it again after. However this is not a good solution.

well... if you have the base_vat module installed the system will not allow you enter customers with the wrong VAT information, so there would be no way of listing that information.

Gustavo
on 12/26/13, 9:13 AM

There are actually many in the database because they are there from before that module was installed.

Jairo Llopis
on 12/27/13, 4:02 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 12/26/13, 9:02 AM
Seen: 1791 times
Last updated: 3/16/15, 8:10 AM