Auto Invoice Number

Scriptcase 9 General
#1

Hello, Appreciate if any one can help me in setting up a procedure where the user can set “Start Invoice Number” and to be stored on the system, so when he generates a new invoice a new number will take over. Such as a configuration file…

thank you,

#2

There are several possibilities, depending on the database used. You can use an autosequence. There’s a manual autosequence option within SC. And finally you can make a small php procedure to do so.

In general: select max(invoicenr) from invoice. Then add 1 to it and apply that as default value.

#3

If you are using an auto_increment value in mysql to get your invoice number, and you want to start from number 1000 instead of number 1, you have to run this SQL sentence to alter your table:


ALTER TABLE myTable AUTO_INCREMENT=1000;

Now your auto_increment field will start from number 1000.

#4

Hey guys! I also have same problem but I recovered in last days…:slight_smile:

Please suggest me and visit :

http://www.fetchflow.com/support/question/How-do-I-schedule-recurring-invoices.html