Question about invoice numbering

[velcro]

Hello everybody,

 

I have a question about the invoice numbering in WHMCS. Our current invoice number in WHMCS that is generated automatically is a lot higher than the number of the real invoices. Therefore we always have to manually change the invoice number manually after an invoice is created.

 

Is there a way to close the gap between the number in WHMCS and the real amount of invoices so we don't have to change the invoicenumbers manually??

 

Thanks a lot in advance!

[scurrell]

Setup > General Settings > Invoicing > Invoice Starting #

[velcro]

But it says that I can't change it to a number lower than the WHMCS invoice number. The number of our current invoice is a lot lower that the WHMCS invoice number.

[WHMCS John]

Can you elaborate more on what you mean by "real invoices"?

[velcro]

I will try to clarify with an example. When we create a new invoice WHMCS gives it number 2120. But in fact it is only invoice number 1240. So every time when an invoice is created we have to change the invoice number manually.

 

Thx

[WHMCS John]

I'm afraid I still don't understand. Surely the number WHMCS generated (2120) IS the invoice number. I'm not sure where you're getting 1240 from?

[scurrell]

Just because you've only got 1240 invoices, it doesn't mean the invoice number has to be the same.

 

Can't see that it matters.

[vedova]

Just because you've only got 1240 invoices, it doesn't mean the invoice number has to be the same.

 

Can't see that it matters.

 

Also we need to have Order Number = Invoice Number

and Order No. reported on pdf....

 

 

we use a different progressive numeration and template/kind of regular invoice,

so we cannot use this in Italy. A lot of whmcs users here create a second invoice for this.

 

How do you suggest to resolve this issue?

 

regarda

 

Emanuele

Vedova Computing

[earthlover]

I will try to clarify with an example. When we create a new invoice WHMCS gives it number 2120. But in fact it is only invoice number 1240. So every time when an invoice is created we have to change the invoice number manually.

 

Thx

 

Hi Velcro,

I think invoice number is generate automaticaly by the function in SQL (auto incremet). So, try to access database, and open table "tblinvoices". It may be come you have some number of data inf tbleinvoices at past time, then delete them and add more data but not restart auto increment number.

 

1. Open table "tblinvoices"

2. Click Structure tab

3. Scroll down, and find out what is next auto-increment value. If not 1241 (because your last invoice number is 1240), you have to re-set it.

4. To set next auto-increment value, click "Operation" tab, and fill auto_increment value with 5 or use this SQL statement:

ALTER TABLE `tblinvoices` AUTO_INCREMENT =1241;

 

Hope it is usefull.

[velcro]

@earthlover

 

Thanks for your reply I will try that.

[WHMCS John]

Whatever change you make to the auto-increment value, I cannot stress how important it is that you set it to a number that has not already been used for an invoice in your WHMCS install.

 

For example if invoice 1000 already exists, and you change the auto-increment value to 1000 via the database then in all likelihood the wrong clients will be invoiced.

[earthlover]

Sorry, I make a mistake. Please check the bold text.

Hi Velcro,

I think invoice number is generate automaticaly by the function in SQL (auto incremet). So, try to access database, and open table "tblinvoices". It may be come you have some number of data in tbleinvoices at past time, then delete them and add more data but not restart auto increment number.

 

1. Open table "tblinvoices"

2. Click Structure tab

3. Scroll down, and find out what is next auto-increment value. If not 1241 (because your last invoice number is 1240), you have to re-set it.

4. To set next auto-increment value, click "Operation" tab, and fill auto_increment value with 1241 or use this SQL statement:

ALTER TABLE `tblinvoices` AUTO_INCREMENT =1241;

 

Hope it is usefull.

 

@earthlover

 

Thanks for your reply I will try that.

You are always welcome.