The SimpleInvoices forum has moved to Google Plus - this forum is now read-only
Change invoice number on beta6
  • ReallyNAReallyNA June 2010

    Hello,

    Can't find the way to change the starting invoice number. I'm on phpmyadmin but can't find the correct place to change the auto-increment.

    I have Invoices, Quotes, Estimates. I need to start with Invoice 21 and Quote 5. Any help?

    Thanks in advance

  • justinjustin June 2010

    hey reallyNA

    refer: http://simpleinvoices.org/forum/discussion/1245/

    try the below sql


    delete from `si_index`;
    INSERT INTO `si_index` VALUES('21','invoice','X',' ','1');
    INSERT INTO `si_index` VALUES('5','invoice','Y',' ','1');


    where X = the ID of the 'Invoice' Invoice preference
    and Y = the ID of the 'Quote' Invoice preference

    let us know how you go

    cheers

    Justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au
  • ReallyNAReallyNA June 2010

    Hey Justin,

    Perfect, that's it. Just one notice: if someone need to start with 21 (like me) the first id should be 20

    Code:

    INSERT INTO `si_index` VALUES('20','invoice','X',' ','1');

    Cheers

  • justinjustin June 2010

    great to hear it worked!

    i'll add this to our FAQs list

    Cheers

    Justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au
  • finleydesignfinleydesign April 2012

    Hi, Sorry to bring this back to life again, but I have done the above successfully, but the PDF and Print out continues to update each invoice from 1,2,3 and so on

Add a Comment

Categories