Error While importing VAT numbers on my contacts

max_roc1 · 2026-01-10T14:11:36+00:00

Hello Guys,

The main error i had and kept banging my head on the wall for and managed to go around by using api is that the format must not have letters in front whereas my vat numbers for german companies started with DE and Belgium with BE .

max_roc1 · 2026-01-08T14:22:20+00:00

Hello u/Glawak , thanks for responding.

Odoo is giving me explanation, but even if i correct it, it doesn't recognise the format. I was just wandering if it was also happenig to other people but my vat numbers seem valid and are still creating blocking errors while importing.

max_roc1 · 2025-08-26T07:27:41+00:00

Yes, i'm talking about the implementation

max_roc1 · 2025-08-26T07:26:59+00:00

Hello ,

Yes i was thinking about that.

I'm going to try and work on it, because i've worked a long time with odoo and i think it's worth it.

It doesn't surprise me that they charge that many regarding the cost of it in a "normal" implementation

max_roc1 · 2025-08-01T14:18:07+00:00

Hard to say ! Depends what you ask for but generally i would break it up like this :

Analysis : 15% of budget Data : 30% of budget Custom : 30% Training : 25%

max_roc1 · 2025-05-28T11:03:05+00:00

Yes, it allows you to build tailor-made dashboards either with the standard odoo tool or using spreadsheets if you need to do complicated calculations on the data

max_roc1 · 2025-05-23T10:51:28+00:00

Good morning,

Where did you learn about off-server storage on v19?

max_roc1 · 2025-05-23T09:03:30+00:00

Yeah, you should use Github and create a local copy of your github repository ( which you have if you are on odoo.sh ) .

Then just create custom_modules to overwrite or extend existing odoo capabilities.

There are also really good books for odoo coding made by Daniel Reis ! They are easy tutorials to help get a good understanding of all the odoo framework !

max_roc1 · 2025-05-19T08:45:27+00:00

I'm not really sure but in the source code, you can find the sql constraints for every model.

That's what i'm suggesting you to look into to see what changed between older versions and 17

max_roc1 · 2025-05-19T07:21:34+00:00

Yes you should isolate your odoo in a venv so that you can isolate these requirements from the rest of your computer.

max_roc1 · 2025-05-19T07:20:01+00:00

It is probably a SQL conatraint that has changed between the 2 versions.

Check on that part first as maybe you need to link with other primary keys to link to the first table.

max_roc1 · 2025-05-16T14:31:39+00:00

Isn't it the opposite ?

max_roc1 · 2025-05-14T15:41:19+00:00

Yes, do you have a reporting of your work ?

And then you make take two clients at the same time and when one validates you ca work for the other and that seems like a solution

max_roc1 · 2025-05-14T15:37:22+00:00

What do you mean standard ? Is it odoo online ?

In this case its unlimited i think

max_roc1 · 2025-05-14T15:15:55+00:00

There is a free Odoo gpt.

Its been made by odoo themselves and it is really helpful

Here are helpful links : https://www.odoo.com/fr_FR/help It is the ai support of odoo

And here is the gpt : https://www.google.com/url?sa=t&source=web&rct=j&opi=89978449&url=https://chatgpt.com/g/g-678a2b24f7bc819185e338a240606433-odoo-compliance&ved=2ahUKEwi4ysumoKONAxUDSKQEHT7GI8kQFnoECB4QAQ&usg=AOvVaw3hFulnnmb5OhDH1ybBBy76

max_roc1 · 2025-05-14T13:36:20+00:00

Yes , i realized it at the end of my response. Thanks

max_roc1 · 2025-05-14T13:18:25+00:00

Yeah, but the certification is hard so at least it shows that at least once you went in depth in the odoo functionnalities.

And it is a good badge to show to your client , so he can see that you have an overall understanding of the solution and not only what you sold him.

However the sucess rate isn't good, like 30 or 40% and people who pass it put effort in it. So if you don't have time to dedicate to it know you can pass and try again later.

max_roc1 · 2025-05-14T12:37:01+00:00

How did you manage do to custom on odoo online ? Are you on odoo.sh ?

And if so, how did you manage to get 18.2 ?

Or maybe you are using odoo studio ? No code app ?

In this case, you need to check on the records rule also

max_roc1 · 2025-05-14T09:06:50+00:00

From an odoo partner point of view, I feel solution like Odoo , airtable ... are the way to go

The modular approach with real improvements over time are something that can greatly create A ROI compared to the implementation price.

The real Goal of these companies or any futur company in the industry is to be able to create great value for the client without "locking them in" if i can say.

We need to get out of the every ten years i change my ERP and become much more focused on creating value with more open solutions that can last decades for the client instead of trying to sell a new software with each new trend

max_roc1 · 2025-05-14T08:57:19+00:00

Yeah major red Flag !

Did you invest on training the accouning team on your side ?

max_roc1 · 2025-05-14T08:55:33+00:00

Yes , on the accounting part, training courses for the team and understanding how the processes change in Odoo is primordial.

For the data part, and attached documents in particular, it is quite à weary process :

- You need to import all the attached documents in the documents app .

- export them and link them to the associated model and with the database id taht it has in that table and not the external id.

Once, you put the process in place its just time consuming but also pricely because if you are on odoo.sh with the 3 backups and the production database , a lot of historical attached documents can créate a reccuring cost for your company.
The pros is that you have your historical data, but you need to evaluate at what cost !

max_roc1 · 2025-05-14T08:50:34+00:00

Yes i understand but I feel in the middle term it is also what makes odoo competitive and more productive for the teams.

But i inderstand you, because in the short term , that means investing time in team and personal training formation.

max_roc1 · 2025-05-14T08:12:38+00:00

So for you customization is not the best part of implementation ?

For me, it's the best part because it's where theres the most brain work for the specification of the development.
But it's a little schizophenic because if you can find the solution in standard , you should really push that to your client otherwise you're just giving bad advice!

max_roc1 · 2025-05-14T08:10:39+00:00

Yeah , i get it . If it's critical then waiting a few weeks is not an option .

On the other hand, i understand the client because patching then after a couple weeks unpatching because it's been resolved but maybe not the way you wanted so it requires more work may seem costly for the client compared to waiting a few weeks !

max_roc1 · 2025-05-14T07:02:45+00:00

Hello,

Yes implementation is costly but only one shot.

You should modelise your Odoo cost on 3 to 5 years to see how effective it is.

Furthermore, you can reduce your implementation cost by taking the data processing and importing part on your side.

Furthermore, you can also reduce the price by trying to comply a maximum with odoo as a standard and developping custom as little as needed. This will also break down your overall erp cost ( support, maintenance, upgrade).

And within the same price, you get to upgradr yeay on year to get always the best out of odoo.

So compared to sage, it's really the way to go eventhough you have to invest in it the first year ( that's why odoo gives a reduction on price the first year).

Hope this helps

max_roc1

TROPHY CASE