How can I recreate a cancelled invoice?

[isdoo]

Hi,

 

I need to recreate a cancelled invoice.

 

All the invoice says in cancelled, with no information in any field.

 

It does not exist anywhere in the database.

 

I appreciate that I will need to manually edit the database - but despite trying it still shows as cancelled, so there must be at least one more table that links everything together.

 

Could someone let me know which tables are used for an invoice.

 

Many thanks.

[Troy]

If you cancel an invoice in WHMCS, it retains the details, and you can just click the "Mark Unpaid" button. If you have a cancelled invoice that is showing no detail, you've probably deleted the detail somewhere along the line. If you mark it unpaid, you should be able to edit or add to the detail of the invoice at that point, unless your data is really screwed up somehow.

[isdoo]

Nope it doesn't exist at all.

 

I need to manually create it in the database

[Troy]

Hmm. I'd probably recreate it as a new invoice for the customer, and then edit the data in the database and change the invoice number.