Obviously the deleted items won’t appear in the si_invoice_item_tax any longer. So I’m wondering that items you are thinking of deleting from this table. I did run a test where I created an invoice with a tax item, then manually deleted it from the si_invoice_item_tax table. Although the si_invoices record still contained the total tax value in the record, when I displayed the invoice, it no longer showed the total tax. And when I went back to the database, the si_invoices tax_amount field was reset to zero (the correct value). So you should be able to reset the values by simply accessing the invoices.
By the way, how is your original issue? Everything displaying OK?
Recent Comments