User authentication is temporarily unavailable. If this situation persists, please inform your Wiki Admin.

Differences

This shows you the differences between the selected revision and the current version of the page.

wiki:how_to_change_the_invoice_number_starting_point 2014/04/14 21:43 wiki:how_to_change_the_invoice_number_starting_point 2016/10/11 06:15 current
Line 1: Line 1:
 +===== 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
 +
 +<code sql>
 +delete from `si_index`;
 +INSERT INTO `si_index` VALUES('999','invoice','1','0','1');
 +</code>
 +
 +refer:
 +  * http://simpleinvoices.org/forum/discussion/1287/change-invoice-number-on-beta6/
 +
 +~~DISCUSSION~~
 +
 
 |