Generate Due Invoices not generating invoice

[LukeDouglas]

I changed a client from monthly to quarterly billing. Here is what I have done:

 

1. On Invoices tab, Last monthly invoice paid was due date 6/01/2016
   
2. Cancelled and Deleted Invoices 07/01/2016 to 11/01/2016
   
3. On Products/Services tab, changed Product/Service from $50/mo to $150/qtr
   
4. Changed Recurring Amount from $50 to $150
   
5. Reset Next Due Date to 06/01/2016 to match up with last Next Due Date that was paid. (FYI, tried 07/01/2016 and 09/01/2016 which was 3 months later
   
6. Checked box for Auto Recalculate on Save
   
7. Click Save Changes
   
8. on Summary tab, clicked Generate Due Invoices
   
9. 0 Invoices Created
   

 

At this point, I am not sure exactly why it is not generating an invoice with due date 09/01/2016 for $150.

 

Is there something that I am not doing which is the issue?

[WHMCS ChrisD]

Hello LukeDoouglas,

 

Once an invoice is deleted you can not re-generate it, the work around for this is to push the next due date out by one day to the 2nd instead of the first and this should then generate the invoice.

[LukeDouglas]

Chris,

 

Thanks. Increased by one day and it generated the invoices.

 

Hello LukeDoouglas,

 

Once an invoice is deleted you can not re-generate it, the work around for this is to push the next due date out by one day to the 2nd instead of the first and this should then generate the invoice.

[rkok]

It can be done at your own risk using a database tweak: find the client's domain in `tblhosting` and change the `nextinvoicedate` field one month back. This is the field WHMCS uses to determine when the next recurring invoice needs to be created.