How can we improve WHMCS?

Share, discuss and vote for what you would like to see added to WHMCS

Cancel X days overdue invoices

  • Angelica Costa shared this idea 9 years ago
  • Payments/Billing
  • 54 Comments


415 Votes
Login to Vote
Sometimes clients do not cancel their plans and their invoices are overdue, still there active messing our reports.

It would be nice if in the automation settings (cron) there would be an option to mark as cancelled invoices that are x day overdue.

E.g: Cancel invoices that are [u]100[/u] days old past their due date.

61 Comments

Login to post a comment.

What I did was build a hook to cancel all invoices that are overdue past 30days, automatically change them to Cancelled.
How about sharing it...
Why is this not a feature yet?
This needs to be a feature.
this request is 7 years old... very unlikely that this will be done.

I made a hook for that, which you can dl here:
https://github.com/wolkenbauer/whmcs-cancelinvoice-hook
Thanks!
Thank you!
Thanks!
This is a very good idea. And for sure needs to happen.
any update?
The easy fix would be when the CRON runs to Terminate a Service/Product to also just Terminate the Invoice.
Now, if there happens to be an invoice not tied to a Service/Product, then allow the Admin to decide when those type invoices are canceled.
i like the idea its logical
I would like to see this as well. Currently this leaves "orphaned" invoices.
It's really annoying to remove manually all unpaid invoices.
I can tell...
Support this all the way. How is this not a default feature?
SELECT id FROM tblinvoices WHERE duedate <= ' ... ' AND status = 'Unpaid'
UPDATE tblinvoices SET status = 'Cancelled' WHERE id = ' ... '

To cron. Thats all :D
this would be very useful! please add this feature.
Think I need to add something for better understanding what we mean with this issue.

There is a HUGE difference between proforma invoice and "normal" (means: VAT) Invoice. In fact a proforma invoice is NOT an invoice at all. It is just a hint that client needs to pay upfront and how much and since when. These invoices can be "cancelled", "deleted" or "painted in red color". It does not matter. After payment, the real invoice will be issued and NOW, there should be an option to disable the "cancel invoice" and "delete invoice" buttons, because these invoice should never ever been touched again or deleted to stay legal. If we want to cancel the invoice NOW partially or in full (for whatever reason) , we have to issue a credit note manually (WHMCS does not provide issuing credit notes) as it is also prohibited by law to issue just another invoice with pure negative balance. Specially for Germany, the credit note must be named exactly as credit note and not "invoice"! (in german: "Gutschrift").
@dexus, I fully agree with that.
This request is actually for auto cancellation of "proforma" invoices.
If you don't use your WHMCS in that way or don't want invoices to be cancelled, you should not enable this option, when/if implemented, since this should of course be optional.
Since negative some comments here do mention the same concern, I also have to agree that those are really valid comments, but that is something that WHMCS actually does not have implemented properly. There should be one more invoice "variant", and those are invoices that must be paid for some already provided services.

WHMCS currently have unpaid (proforma) invoice, and paid invoice, but does not have option to make unpaid invoice to something like "service provided / must be paid". That is the invoice type that really can not be cancelled as mentioned before, but most invoices for domain renewals or orders that were never paid can be safely cancelled, since those services were not provided, and clients should not be obligated to renew hosting account or domain registration.

So there should definitely be some additional options to fine tune this auto cancellation.