Change VAT in billing module

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

  1. Davide

    Davide Member

    Is it possible to change VAT in all recurring items/item templates at once?
     
    Davide, Oct 17, 2012
    #1
  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:

    Code:
    UPDATE invoice_item_template SET vat = 15 WHERE vat = 19;
     
    till, Oct 17, 2012
    #2
  3. pititis

    pititis Member

    Good point Till, thank you
     
    pititis, Oct 17, 2012
    #3
  4. Davide

    Davide Member

    In case of Recurring items:
    Code:
    UPDATE invoice_recurring_item SET vat = 15 where vat=19;
     
    Davide, Oct 17, 2012
    #4

Share This Page