Is there a way to remove old invoices of terminated accounts?

[Web Host Pro]

It looks like WHMCS is terminated accounts that are the set past due but it's not removing the invoices. Is there a way for WHMCS to see if the account is terminated or cancelled and remove the invoice if it is?

[WHMCS ChrisD]

@Web Host Pro something like https://marketplace.whmcs.com/product/2622 would assist you

[Web Host Pro]

Wow, interesting thanks. I'll try it.

[DennisHermannsen]

It can also be done using a hook.

<?php

$daysBeforeCancel = '60'; //Change this to how many days you want to wait for the system to cancel an invoice after the due date

use WHMCS\Database\Capsule;
add_hook('DailyCronJobPreEmail', 1, function($vars) {
	$command = 'GetInvoices';
	$postData = array(
		'status' => 'Overdue',
		'limitnum' => '700', 
	);
	$results = localAPI($command, $postData);
		
	foreach ($results['invoices']['invoice'] as $cancelInvoice){
		if(strtotime($cancelInvoice['duedate']) < strtotime($daysBeforeCancel)) {
			$command = 'UpdateInvoice';
			$postData = array(
				'invoiceid' => $cancelInvoice['id'],
				'status' => 'Cancelled',
				);
			$results = localAPI($command, $postData);
        };

	}

});

 

[Andrea D.]

On 1/3/2019 at 12:02 AM, DennisHermannsen said:

It can also be done using a hook.

<?php

$daysBeforeCancel = '60'; //Change this to how many days you want to wait for the system to cancel an invoice after the due date

use WHMCS\Database\Capsule;
add_hook('DailyCronJobPreEmail', 1, function($vars) {
	$command = 'GetInvoices';
	$postData = array(
		'status' => 'Overdue',
		'limitnum' => '700', 
	);
	$results = localAPI($command, $postData);
		
	foreach ($results['invoices']['invoice'] as $cancelInvoice){
		if(strtotime($cancelInvoice['duedate']) < strtotime($daysBeforeCancel)) {
			$command = 'UpdateInvoice';
			$postData = array(
				'invoiceid' => $cancelInvoice['id'],
				'status' => 'Cancelled',
				);
			$results = localAPI($command, $postData);
        };

	}

});

 

Hello! Thank you for sharing the code but unfortunately it is not working for me. Do you think this code is outdated?