Jump to content

Changing Invoice Numbers


Recommended Posts

Due to some internal reasons, I need to change the invoice numbers that are already being created. Could you please let me know how to re-arrange the invoice numbers?


Or is it possible to re-generate all the invoice numbers?


Thanks for your help.

Link to comment
Share on other sites

In our installation (WHMCS 3.5.1) I can change the invoice number in the "Options" tab of the invoice from the admin area. I already had to do this on one invoice that we had imported from our previous billing system and had no issues. Just make sure that your templates are updated to use the invoice number field rather than invoice ID as was the case in 3.4.x


The invoice number is stored in the database in a separate field "invoicenum" so you should be able to bulk update those via SQL commands if required without having to resort to doing everything thorough the admin screens.

Link to comment
Share on other sites

Thanks for your reply Nitro.


Configuration > Invoices >


Invoice Starting #


You should only enter this if you want to change the invoice starting number

The number you enter here must be greater than the last generated invoice # which is 5050


If I change the invoice number here (let's say 6000), will all the invoices number be re-generated for all the orders according to the date?

Link to comment
Share on other sites

existing invoice will not be regenerated / changed, you will need to change those numbers manually in the way I mentioned earlier. then you set a new starting number in the location you mention and WHMCS will use this for any new invoices


you could do easily enough if you just want to add 6000 to invoice numbers use SQL something like:


UPDATE tblinvoices SET invoicenum = id + 6000 WHERE invoicenum = '';


You will need to understand this SQL and make sure it is doing what you want before you run it, also don't forget to ake a backup first - no responsibility taken here if you trash your DB.

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