Tax rates are not taken automatically

Using my Dolibarr
1

Greetings, Com!

Okay, with a fresh imported stock of customer-adresses and products I tried to create an offer.

One point where I stuck for a moment was the fact, that Dolibarr always uses 0% tax instead of the german-typical 19%.

A view into the setup gave me the right hint: The Doli-rules say, that the 19% are set as far as the customer-country and my own country are the same. Well, there was no opportunity to import a country with the CSV-file and I also guess, the system either uses a code for that.

So to change all third-party-countries to “Germany” might help…

Now my question:
There are way too much entries to do all this by hand. In which field in the database can I find the country-codes related to the third-party-people? They do not seem to be saved in the “llx_societe”-table…

Or is there a general way to change the rules themselves?

Pre-Thanks!

PS:
Sorry for telling so much (each time) before I get to the point. ^^ But I think it might help people, who stand in front of the same problem if they find themselves again in the text and the problematique.

2

The field to defined country for a third party is field fk_pays into table llx_societe.
It must be an integer that is the id of country found into table llx_c_pays (for germany, it should be 5).

I will add a way to import country by import wizard, at least the id of country.

3

Okay, once again the solution for all:

A login into the SQL-Database, SQL-command:

UPDATE llx_societe SET fk_pays= 5

…and all was fine! A great database filled up with Germans :happy:

Thanks alot, Eldy!

I think to integrate it into the import-wizard would be a nice improvement!