You are here

Simpleinvoice: How to change the invoice number starting point

Note: this is for Simple Invoices 2010.2 and above

Say you want the have the invoice number start at 1000 instead of 1

Open phpMyAdmin, go to your Simple Invoices database, then find the si_index table. Then click browse, the data should look something like

id node sub_node sub_node2 domain_id
1 invoice 1 0 1

edit this row and change it to below

id node sub_node sub_node2 domain_id
999 invoice 1 0 1

or just execute the below SQL 

DELETE FROM `si_index`;
INSERT INTO `si_index` VALUES('999','invoice','1','0','1');

refer:

code type: 
query