Jump to content
  • 0

Best Way To Void A Bunch Of Invoices


Question

Posted

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?

5 answers to this question

Recommended Posts

  • 0
Posted

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.

  • 0
Posted

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!

  • 0
Posted

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?

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...