starting invoice number for invoice groups
  • mwestrikmwestrik December 2011

    Hi,

    I'm trying to set up an invoice group system, with different invoicce numbers for the two groups. I first tried by just changing "id" in the "si_invoices" table, but then in the "manage invoices" list it still says invoice 1, etc. So I changed "index_id" as well.

    What I encounter now is that invoice numberings are mixed. The "Id" increments from the same starting number for ALL invoices, from both groups. Apparently I've changed something I should not have done.

    Can anybody explain me how to set things right, so two invoice groups, with different starting numbers, both showing up on the invoices as well as in the "manage invoices" table. One invoice group has to start at 20120001 and the other one starts at 20125001.

    Thanks for any help provided.

  • modirmodir December 2011

    Hi,

    See here for more information:
    http://code.google.com/p/simpleinvoices/wiki/HowTo#..._change_the_invoice_number_starting_point

  • mwestrikmwestrik January 2

    thanks, but that does not do the thing correctly. It does indeed change the starting number in the invoice list, but on the invoice itself, it still says "2" instead of 20120001.

  • mwestrikmwestrik January 2

    Why is there a difference between the numbering on the invoices themselves and the numbering in the invoice list in the first place? Why would that be helpful?

  • modirmodir January 2

    Once an invoice has a number it will always have this number. The list only has influence on new invoices. Does this make it clear now?

    You would have to edit the already created invoices by hand if you want to change the number.

  • mwestrikmwestrik January 2

    sorry, but it is not true, or it does not work that way for me.

    I've set the starting invoice numbers the way you said me to.
    When I created an invoice, the invoice list (.../index.php?module=invoices&view=manage) did show the correct number, but on the invoice itself was printed "2". Then I craeted an invoice for the other invoice numbering group. On the list it did state the correct number (the other starting number),but on the invoice it did say "3". So to each of the invoices there were two different invoice numbers assigned, each one with autoincrement. One of these numbers is defined in the table "si_index and then also displayed in the column "index_id" of the table "si_invoices". The other number is the "id" column of the table "si_invoices".

    Probably the solution might be to change the number that is displayed on the invoices themselves from {$invoice.id} to {$invoice.index_id}. Will that work?

    Another thing: I've created two invoice preferences for these two numbering groups. Is it somehow possible to assign different templates to these two? The problem is that these numbering groups are set up for two different languages: i.e. one is set up in Spanish and the other one in Dutch, both with hardcodes wordings, and some changes in layout. I am able to use the different numbering groups, and the invoices created for them do insert the corresponding logos, but they all do use the same template. I cannot find out how to give them different templates. Anyone have an idea how to do that?

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