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 00:38.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.