WHMCS auto delete overdue invoices hook

conlustro

Does anyone have or can anyone write a WHMCS hook to auto delete overdue invoices older than 100 days in WHMCS? I'd like to run the hook as a daily cron job. Thank you!

PetaByet

PM me.

BharatB

I can , is it paid or do you need the code written free ?

rds100

So how many overdue invoices do you have?It seems like a manual job of 2-3 minutes you need to do every month or something.

conlustro

This is a sample hook:

 <?php
 
 function hook_create_forum_account($vars) {
 
     $firstname = $vars['firstname'];
     $lastname = $vars['lastname'];
     $email = $vars['email'];
 
     # Run code to create remote forum account here...
 
 }
 
 add_hook("ClientAdd",1,"hook_create_forum_account");
 
 ?>

That's all it is, and I don't need it that much so I'm not going to pay anything for it. I just wanted to know if the community already had something or had enough experience to write a hook out. I have a couple hundred invoices, and it would be nice to not have to go in there and do it myself.

LeonardC

UPDATE `tblinvoices` SET `status` = 'Cancelled' WHERE `duedate` <= DATE_SUB(CURDATE(), INTERVAL 100 DAY) AND `status` = 'Unpaid'</pre>

dcc

This one worked for us before: https://www.whmcs.com/appstore/138/Cancel-Invoice-On-Termination.html

MetroVPS_NMP

Sent PM @PetaByet