Jump to content
xlegends

Invoice generation issue

Recommended Posts

latest whmcs stock, no mods/php71/centos7/nginx+php-fpm

---------------------------------

 

About 3 weeks ago, I created a demo product X for purchase $10 (one time purchase)

Yesterday, I manually converted it to a monthly cycle product and painstakingly manually changed it for all of the 93 customers to 1 month cycle .. 

My first renewal invoice generation is set for 10 days before due date for all products globally. 

Crons are running fine and other products, invoices, suspensions and terminations are working good. 

 

However, this product X, the first set of renewals should be coming due on 10/3 which is within 10 days so they never got a renew invoice

I waited over night to see if crons will generate an renew invoice for them but it didnt.. 

How can I force generate them an invoice without globally changing the 10 day invoice setting (I dont want other products to be affected)

Share this post


Link to post
Share on other sites


[root@epic ~]# php -q /home/admin/web/mydomain.com/whmcs777/crons/cron.php -F all -vvv

WHMCS Automation Task Utility: all
==================================

 Daily Cron Automation Mode

Queuing Tasks
-------------

 Force run any tasks: ignore "in progress" and "is due"
 Task queues ready

Executing Application Queue
---------------------------

  0/26 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   0% < 1 sec/< 1 sec 20.0 MiB
 Currency Exchange Rates
  1/26 [▓░░░░░░░░░░░░░░░░░░░░░░░░░░░]   3% < 1 sec/< 1 sec 20.0 MiB
 Product Pricing Updates
  2/26 [▓▓░░░░░░░░░░░░░░░░░░░░░░░░░░]   7% < 1 sec/< 1 sec 20.0 MiB
 Invoices
  3/26 [▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░░]  11% 11 secs/1 min  32.0 MiB
 Late Fees
  4/26 [▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░]  15% 11 secs/1 min  32.0 MiB
 Credit Card Charges
  5/26 [▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░]  19% 11 secs/57 secs 32.0 MiB
 Invoice & Overdue Reminders
  6/26 [▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░]  23% 12 secs/52 secs 34.0 MiB
 Domain Renewal Notices
  7/26 [▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░]  26% 13 secs/48 secs 34.0 MiB
 Cancellation Requests
  8/26 [▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░]  30% 13 secs/42 secs 34.0 MiB
 Overdue Suspensions
  9/26 [▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░]  34% 13 secs/38 secs 34.0 MiB
 Overdue Terminations
 10/26 [▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░]  38% 13 secs/34 secs 34.0 MiB
 Fixed Term Terminations
 11/26 [▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░]  42% 13 secs/31 secs 34.0 MiB
 Inactive Tickets
 12/26 [▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░]  46% 13 secs/28 secs 34.0 MiB
 Delayed Affiliate Commissions
 13/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░]  50% 13 secs/26 secs 34.0 MiB
 Affiliate Reports
 14/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░]  53% 13 secs/24 secs 34.0 MiB
 Email Marketer Rules
 15/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░]  57% 13 secs/23 secs 34.0 MiB
 Credit Card Expiry Notices
 16/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░]  61% 13 secs/21 secs 34.0 MiB
 Server Usage Stats
 17/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░]  65% 14 secs/21 secs 34.0 MiB
 Overage Billing Charges
 18/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░]  69% 14 secs/20 secs 34.0 MiB
 Client Status Update
 19/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░]  73% 14 secs/19 secs 34.0 MiB
 Domain Expiry
 20/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░]  76% 14 secs/18 secs 34.0 MiB
 Ticket Escalation Rules
 21/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░]  80% 14 secs/17 secs 34.0 MiB
 Data Retention Pruning
 22/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░]  84% 14 secs/17 secs 34.0 MiB
 WHMCS Updates
 23/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░]  88% 16 secs/18 secs 42.0 MiB
 Run Jobs Queue
 24/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░]  92% 16 secs/17 secs 42.0 MiB
 Domain Transfer Status Synchronisation
 25/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░]  96% 17 secs/18 secs 42.0 MiB
 Domain Expiry Synchronisation
 26/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100% 17 secs/17 secs 42.0 MiB


 Sending Daily Cron Digest email

Executing System Queue
----------------------

 4/4 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100%  1 min/1 min  60.0 MiB


 [OK] Completed


[root@epic ~]#
 

Share this post


Link to post
Share on other sites

It’s an interesting issue!

When you changed the renewal dates, did it fall within the 10 days or was it 11,12 etc?  I am wondering whether WHMCS does not trigger if within the 10 days but would trigger if it counted down to 10 days.

Share this post


Link to post
Share on other sites

Ok after running that command 56/93 invoices were generated of those 93 clients who are within 10 days of expiry. Looks like its working now.

I think what happened was I made the change after the daily crons digest daily cut off time last night. I would have generated them later tonight. 

Share this post


Link to post
Share on other sites

Since I updated WHMCS to the latest version, the cron generates an invoice before the actual date which is very strange. Example, the cron is set to run at midnight, but exactly 1 hour before at 11PM, it generates the invoices for tomorrow. In the past users received the invoice exactly at midnight, now they receive it one hour before, or the day before which is really strange. I never had a problem with the cron until I updated WHMCS. Both PHP and the server time are correct and match. I'm not sure if this is related to your issues but there is something screwed up about WHMCS is now calculating dates.

Share this post


Link to post
Share on other sites

in my case I converted the cycle from one-time to monthly and just didnt wait long enough for next cron process..

 

Be sure u uncomment ; timezone in PHP. Ive made that mistake before. 

check help - system health to see if it complains about time zone

You may also want to use a time-sync server. Webmin has a built in module for this under hardware. 

Share this post


Link to post
Share on other sites
1 hour ago, xlegends said:

in my case I converted the cycle from one-time to monthly and just didnt wait long enough for next cron process..

 

Be sure u uncomment ; timezone in PHP. Ive made that mistake before. 

check help - system health to see if it complains about time zone

You may also want to use a time-sync server. Webmin has a built in module for this under hardware. 

Timezone is not commented in my PHP settings. This started to happen after I upgraded PHP and WHMCS. Its not a big issue, its just generating invoices exactly 1 hour before the actual date at 11 PM instead of 12 PM. This can confuse some people if they happen to read the new invoice email immediately, since its still the date before.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated