The SimpleInvoices forum has moved to Google Plus - this forum is now read-only
Invoice numbering
  • locolocolocoloco February 2011

    Hi,

    First of, I love SI. I have used Bamboo Invoice for a while, but its not suiting my needs..

    I have a problem when it comes to invoice numbering. For the last 4 years, I have used 3 different invoice-systems, who all had a different way to numbering the invoices. And in norway we have to keep invoices stored in minimum 10 years, and I will also have the opportunity to go back and view my old invoices.

    So I have a numbering group who starts with 113>, and one randomly like 88424579, and one starting with 1014>.
    I would like to have the possibility to keep these numbers when I "import" invoices manually.

    Is there a way to select a starting number for one invoice-group? Or a text-field I can write in the number I want?


    Can anyone help me with this?

    Regards,

    Erik.

  • aducomaducom February 2011

    Try searching the wiki, afaik it is possible. Does this help you?

    http://www.simpleinvoices.org/wiki/invoice_numbering_groups

  • locolocolocoloco February 2011

    Well, the problem is that if I choose a invoice numbering group, the group starts with 1. I need it to start with ie 1018 or 113.

    But thanks for the help! :)

  • mattantwestmattantwest February 2011

    Hi locoloco,

    If you are trying to match up the starting number in SI to the last invice number from your previous system you can try running this query on your mysql server

    ALTER TABLE

    AUTO_INCREMENT = ;I hope this helpsMatt

    Developer City Web Design :: Coding Skyscrapers
  • locolocolocoloco February 2011

    Hi matt.developercity,

    That would help me! But I am new to MySQL, so if you could describe how i do this, it would be great!

  • mattantwestmattantwest February 2011

    Hi locoloco,

    I'm not sure of your specific set-up so this might not work but if you're using PHPmyadmin you can do this:

    Open up the database and select the si_invoices table.
    Click on the 'SQL' tab and input this in the text box.

    ALTER TABLE si_invoices AUTO_INCREMENT = whatever_number_you_want;

    Just click go and it should work.

    Let me know how you get on.

    Matt

    Developer City Web Design :: Coding Skyscrapers
  • locolocolocoloco March 2011

    Hi matt.developercity,

    I´ve been busy for a while, but I am back on the project again ;)

    I tried to run the SQL-query you provided, and it only changed the id:
    http://domain.no/billing/index.php?module=invoices&view=quick_view&id=40 to &id=1023

    I put all my old invoices into an invoicegroup called "old invoices", and I`m going to invoice from "Invoice" in the future.

    The invoice number is still 40. I dont know what I am doing wrong here... I hope you can guide me :)

Add a Comment

Categories

Tagged