HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)

- Plugins/Modules/Addons (http://www.howtoforge.com/forums/forumdisplay.php?f=34)

- - Change VAT in billing module (http://www.howtoforge.com/forums/showthread.php?t=59129)

Davide

17th October 2012 03:55

Change VAT in billing module

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

till	17th October 2012 08:32

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:

Code:

UPDATE invoice_item_template SET vat = 15 WHERE vat = 19;

pititis

17th October 2012 09:25

Good point Till, thank you

Davide

17th October 2012 23:44

In case of Recurring items:

Code:

UPDATE invoice_recurring_item SET vat = 15 where vat=19;

All times are GMT +2. The time now is 01:18.