Update Tax rate for unpaid invoices

[artaweb]

Hello,

We've recently enabled TAX in our system as per regulation that was applied in our country. We have added 9%, everything seems to be working as expected however all unpaid invoices are still untaxed.

Is there a way to add the tax amount of 9% to all existing unpaid invoices? 

I'd appreciate your insight on this. 

[artaweb]

If anyone needs the solution, run this mysql query:

UPDATE tblinvoices SET taxrate=9,tax=subtotal*0.09,total=subtotal+tax-credit WHERE status='Unpaid' AND tax=0;

 

[Bidi]

On 4/6/2022 at 12:49 AM, artaweb said:

If anyone needs the solution, run this mysql query:

UPDATE tblinvoices SET taxrate=9,tax=subtotal*0.09,total=subtotal+tax-credit WHERE status='Unpaid' AND tax=0;

 

 

You saved me, thank you!

[Newton]

Be careful, if you have business client in Europe and do this for VAT, it will supersede the VAT exempt status of those clients (meaning the query will add the taxes on ALL invoices).