Change VAT in billing module

Discussion in 'Plugins/Modules/Addons' started by Davide, Oct 17, 2012.

  1. Davide

    Davide New Member HowtoForge Supporter

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

    till Super Moderator Staff Member ISPConfig Developer

    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;
  3. pititis

    pititis Member

    Good point Till, thank you
  4. Davide

    Davide New Member HowtoForge Supporter

    In case of Recurring items:
    UPDATE invoice_recurring_item SET vat = 15 where vat=19;

Share This Page