Long story short I imported several thousands of Sale Invoices from another system and a lot of the statuses are wrong.
What would happen if I changed the status of each using sql queries in the tabSales Invoice table, say from submitted to paid or cancelled. Will that be enough? I suspect that is not the case.
What other tables will need to be altered so that all data is correct in the end?