Editing invoices WHMCS

If you are using WHMCS then you will know that following the latest update you can no longer edit the invoice. 

We hope the next update will rectify this but in the meantime below is a work around.

Steps in phpMyAdmin

1. Go to phymy admin
2. Find the database
3. Go to tblinvoices
4. Find the invoice you want to edit (You can use the filter at the top)
5. Locate the invoice by the id column and make a note of this.
6. Run the following sql

UPDATE tblinvoices
SET status = ‘Draft’
WHERE id = 123;

Replace 123 with the invoice ID.

Once the invoice is back into draft you can edit the details.

We await the next WHCMS update for this to be reverted back.

Contact me if you get stuck.