VAT rate change help

[hatster]

Hi Guys,

 

Our VAT rate here in Spain is due to change from 18% to 21% on the 1st September. In Spanish accounting, vat is calculated on the day of payment, NOT on the day of the order/invoice (as in the uk for example). When i change the vat rate in whmcs is there any way to apply this new rate to all existing invoices ?

 

Thankyou,

 

James,

[Vox]

Hi James,

 

There was a "How to" guide written for the UK VAT increase which covers this for you at http://docs.whmcs.com/How_To_Guides

 

It looks like you would need the third set of code modified to do what you want e.g.

 

UPDATE tblinvoices SET taxrate=21,tax=subtotal*0.21,total=subtotal+tax-credit WHERE status='Unpaid'

AND taxrate=18 AND duedate>='2012-09-01';

 

As with all DB actions back up and test, test, test before you apply it to live!

[Vox]

VAT rate here in Spain is due to change from 18% to 21% on the 1st September.vat is calculated on the day of payment, NOT on the day of the order.

 

 

 

regards,

Bizworldusa.

 

Yep, So that's why I guess you run the query for UNPAID invoices. Whether or not you want to include a due date depends on your invoice profile.

[mtk]

simply remove the date condition from the query:

AND duedate>='2012-09-01'

 

it will update every Unpaid invoice, so every client that will pay from now on will actually pay 20% and not 18...

(it doesn't matter when the invoice is due and/or when was it created)