Changing Invoice id start point

[HostingPup]

Hi,

 

I did abit of a search on this but can't find anything relating to it.

 

We used modenbill before whmcs and have a list of order numbers we dont want to be repeated. (for logical reasons)

 

Is it possible to insert a string to have whmcs start invoice id's from say 9001?

 

We already have had 20 or so invoices been put out by the system but its very confusing for us since we have done a spredsheet with every invoice id since modernbill. Which allows us to quickly and effiecintly get documents to the accountant for tax etc.

 

If it is possible to change the starting point of the invoice id's. How could i do it?

 

Thanks

John

[Matt]

Simply run the following MySQL command on your database:

 

ALTER TABLE tblinvoices AUTO_INCREMENT = 100

 

Replace 100 with whatever you want the next invoice number in WHMCS to be.

 

Matt

[HostingPup]

that worked brilliantly

 

Thanks Matt!

 

 

 

cheers,

John