Jump to content

Next Due Date being ignored


Recommended Posts

The script insists on invoicing one client on the wrong date with the wrong due date, and the only thing I can do is manually correct each invoice every month, AFTER it has been sent to the client.


Here are my current key settings:



Prorata Billing = Yes

Prodata Date = 1

Charge Next Month = 21



Invoice Generation = 7 days before due date

CLIENT PROFILE > Products & Services

First Payment Amount = $24.52

Recurring Amount $20.00

Billing Cycle = Monthly

Next Due Date = 01/12/2007


INVOICE (Auto Generated - wrong)

Invoice Date = 18/11/2007

Due Date = 25/11/2007

Description = Business Plan (25/11/2007 - 22/12/2007)


INVOICE (Should be)

Invoice Date = 24/11/2007

Due Date = 01/12/2007

Description = Business Plan (01/12/2007 - 31/12/2007)


Has anyone found a way to fix this?



Link to comment
Share on other sites

Yes I was suffering from this problem also. A work-around I was given by Matt:


UPDATE tblhosting SET nextinvoicedate=nextduedate;

UPDATE tblhostingaddons SET nextinvoicedate=nextduedate;


This set's the invoice generation date for accounts with product/service and addons to the nextdue date you set.


Make sure to go through your customer list and set all 'Next Due Dates' appropriately to what you want and then run the SQL script to make sure all nextinvoicedate's sync up to the nextduedate you set.


Then your invoices should generate at the right date you want them to.


Before I had this solution our invoices were a real mess, half would generate in the middle of month, the other at the end, sometimes addons for the same account would generate at a different date than the product/service.


This tidied it up for us big time. Hope it helps you.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

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