Best Way To Void A Bunch Of Invoices

[gutterboy]

I have a dozen or so test clients setup, all of which have a number of invoices which haven't yet been sent. I need to run the cron manually but am trying to avoid a barrage of emails coming in.

 

I can't seem to delete the invoices (only void them and this appears to be only doable one by one) and I also can't seem to delete the clients either because...

 

"The client you are trying to delete has invoice, service, or transaction data. Deleting the client will cause a data anomaly. You may wish to mark the client as inactive instead."

 

Is there a way to do what I want? ...even manually via the database?

[Michael]

You can do it by doing: 

UPDATE `invoices` SET `status` = 'void' WHERE `clients`.`client_id` = '1'; 

1 = Client ID.

 

To get Client ID go to their profile at the top you will see: /clients/view/742/ 742 is the client ID.

[gutterboy]

You can do it by doing: 

UPDATE `invoices` SET `status` = 'void' WHERE `clients`.`client_id` = '1'; 

1 = Client ID.

 

To get Client ID go to their profile at the top you will see: /clients/view/742/ 742 is the client ID.

 

Thank You!

[gutterboy]

Would I also be able to delete all the records manually in that table or is there also other tables that contain data that need to be removed as well? Just trying to clear clutter.

[Michael]

Would I also be able to delete all the records manually in that table or is there also other tables that contain data that need to be removed as well? Just trying to clear clutter.

 

Since it's a test installation it would be easier just to re-install to clear clutter mate?

[gutterboy]

Since it's a test installation it would be easier just to re-install to clear clutter mate?

 

I suppose it would lol