Delete Invoice Items when Invoice is Deleted
I just spent a little time trying to figure out how to regenerate an invoice on a product/service after accidentally deleting the unpaid invoice which was generated for that service earlier in the day.
I found the trick to make that happen is here. That led to realize that the tblinvoiceitems table isn't properly maintained when invoices are deleted.
Would you mind modifying the routines which run when deleting an invoice to also delete the items for the deleted invoice from the tblinvoiceitems table? I can't think of a reason to keep those items in the table when the related invoice is no longer in the system. I have a couple hundred lines of useless data in the tblinvoiceitems table.