Services getting suspended and Next Due Date not updating

[toufiq]

Hi there,

 

I have developed a Third Party Gateway module for my employer to handle Direct Debit invoice payments using Ezidebit. Everything works as expected but only issue we are facing is that once an invoice is marked as paid the "Next Due Date" is not being updated automatically as expected and therefore, the service is getting suspended!

 

Direct Debit payments takes a couple of days to complete and so I needed a status to indicate that the invoice is currently being handled by the payment gateway (Ezidebit). As WHMCS does not have any Pending status for invoices, I have added a custom status "Pending" by updating the invoice directly in the database. We run a cron script to update the statuses of the direct debit payments. Once payment is successful after a transaction is applied (through gateway callback function) and invoice status is changed to Paid (also adding the date paid to the day its been paid). WHMCS does not seem to update the service's Next Due Date when the invoice is paid. In turn, the service (with recurring payment) gets suspended automatically. Today over 50 of our services have gotten suspended and we are manually un-suspending them. I am not sure what am I missing here or is it a WHMCS bug? What does trigger the update of the Next Due Date of a service with recurring payment?

 

Any help would be greatly appreciated.

 

Thanks!