canuckhost Posted December 14, 2012 Share Posted December 14, 2012 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 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted December 14, 2012 Share Posted December 14, 2012 Hi SELECT * FROM tbldomains WHERE DATEDIFF(NOW(),nextduedate)="-1" You can do the same for tblproducts, addons and so on. 0 Quote Link to comment Share on other sites More sharing options...
RPS Posted December 31, 2012 Share Posted December 31, 2012 Wow, that actually would be a nice thing to add to the reporting system. 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted January 2, 2013 Share Posted January 2, 2013 (edited) 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 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.