Reset Due Date

[analog]

Hello, I'm just getting accounts setup in my new install, and ran into a problem. I generated invoices for a client, and discovered I had made some mistakes in the account setups. When I go to delete the invoice that is mistaken, it warns me that the items will not be reinvoiced. So, how do I reset the due date so that when I run invoices again, the system picks up my corrections?

[othellotech]

>So, how do I reset the due date so that when I run invoices again,

>the system picks up my corrections?

 

remove the records manually from the tblinvoices and tblinvoiceitmes if you're still testing

or just change the invoice to the right things if lparallel running

or change the due-date back 1 day on the product of you're live

[analog]

I'm not comfortable deleting things directly from the database. I'm not sure what lparallel is.

 

I deleted the invoice, and when I look at the customer's product page, it shows the next due date being 10/01/2008. I've not invoiced this particular customer for October yet, so that's the month I'm starting with. I tried to generate invoices again, and zero were created, even though all of his products show a due date of 10/01/2008. So, I'm still confused as how to do this. Any other ideas?

[othellotech]

I deleted the invoice, and when I look at the customer's product page, it shows the next due date being 10/01/2008. I've not invoiced this particular customer for October yet, so that's the month I'm starting with. I tried to generate invoices again, and zero were created, even though all of his products show a due date of 10/01/2008. So, I'm still confused as how to do this. Any other ideas?

 

You deleted the *invoice* but that doenst delete the *invoice items* so no, you cant regenerate that one

 

Either delete each *item line* from the invoice first before deleting the invoice, or see my earlier post

 

|parallel - at the same tiem as another live system - i.e. dual running odl and new services

[analog]

I only have the one install of WHMCS. I decided to dabble in the database after taking a backup. So, I emptied out tblinvoiceitems, tblinvoices was already empty. I then went back in and ran Generate Due Invoices, which did the same thing. Zero invoices generated. All of his products still show a due date of 10/01/2008. Am I missing something else here?

[analog]

Ok, I figured out how to tweak this. In tblhosting, you have to change the column nextinvoicedate. Then it will generate invoices based on that entry. To do this in WHMCS, you have to toggle the Next Due Date setting. Just leaving it set to the existing entry of 10/01/2008 make the software ignore it. If you change it, it also changes the nextinvoicedate entry in the DB.

 

This could be a bit more straightforward. If the system says Next Due Date is a certain date, then that should be what invoices are generated on, or there should be another separate field for Next Invoice Date.

[othellotech]

If the system says Next Due Date is a certain date, then that should be what invoices are generated on, or there should be another separate field for Next Invoice Date.

due date changes on receipt of payment, its not invoice related as such.

 

when you deleted the invoice you were told ...

[analog]

Oh, I understand I was told. That is what prompted this thread in the first place. But, it should be easier to reset the next invoice date, rather than having to guess about toggling the next due date, and then watching the actual DB tables.