Easy way to see the invoices that will be generated tomorrow

[canuckhost]

Hi all,

 

Does anyone know of an easy way to see a list / report of the new invoices that WHMCS will generate overnight (next cron run)?

 

Thanks in advance,

canuckhost

[Kian]

Hi

 

SELECT * FROM tbldomains WHERE DATEDIFF(NOW(),nextduedate)="-1"

 

You can do the same for tblproducts, addons and so on.

[RPS]

Wow, that actually would be a nice thing to add to the reporting system.

[Kian]

I've integrated this in a custom module and it's really useful (original article). Anyway i update it so frequently with advanced filtering options and visual stuff that i'm unable to remember all its features.

 

Screenshot:

http://davidemantenuto.pro/wp-content/uploads/2012/12/nic-whmcs-module-auto-delete-expiring-domain-4.png

Edited January 2, 2013 by Kian