Change invoices numbering
  • FakeMothFakeMoth January 2010

    Hello how can I increment the number of my starting invoice? This is needed due to the fact that i can't update my old SI instance - everything goes blank so i'm starting a fresh install and migrate a few things... by hand, copy/paste style :) Problem is starting with invoice number one, how can I make it start with 100 for example, and increment accordingly? Is there an easy and safe way, a-one-edit-to-database style?

    Thanks!

  • justinjustin January 2010

    hey fakemoth

    search for forum for 'mysql auto-increment' for full details - you just have to use phpmyadmin to change the autoincrement for the si_invoice table for the ID field

    and this should do what you want

    cheers

    justin

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

    Thanks it works - searched the forums but didn't find anything the first time.

    Ah, A Happy New Year!

  • justinjustin January 2010

    great to hear it worked !

    cheers

    justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au
Add a Comment

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories