Change VAT in billing module

[Davide]

Is it possible to change VAT in all recurring items/item templates at once?

[till]

You can do this with a sql command directly in the database. If your new vat rate is e.g. 15% and the old vat rate is 19%, the run this sql query in the ispconfig mysql database with e.g. phpmyadmin:

UPDATE invoice_item_template SET vat = 15 WHERE vat = 19;

[pititis]

Good point Till, thank you

[Davide]

In case of Recurring items:

UPDATE invoice_recurring_item SET vat = 15 where vat=19;