3 Replies Latest reply on Jul 25, 2012 2:46 PM by philmodjunk

    Resetting invoice number for year end.



      Resetting invoice number for year end.


      Hi everyone.

      Ok so I’m new to this forum and to file maker as a program. So first of, hello!


      Now for my problem, as the title says, I’ve made a database of all my costumers and on there individual cards there is an invoice making part of it. Now the thing is I cant right over the invoice numbers that I have already used, 112 113 114 for example. The only way I can find to us those numbers again is to delete the invoice attached to that number then I can make a new invoice using the same number. But the thing with that is, I don’t want to delete all the old invoices.

      So my question is, is there a way to use the same numbers again but with new invoices, all in the same all the database and keeping all the invoices from the first round of numbers.


      I hope this makes sense and someone can help me get it sorted, as I’m sure there’s a way!


      Thanks, Jack.

        • 1. Re: Resetting invoice number for year end.

          Why would you want to use the same invoice numbers again? This can create confusion as you now have invoices with the same invoice number. If you use the invoice number as the key in a relationship, this can be a disaster.

          It can be done, as a script can be used to reset the "next serial value" or you can update it manually, but this does not sound like a good idea. I'd just let the invoice numbers continue to increment year after year.

          • 2. Re: Resetting invoice number for year end.

            Thanks for getting back to me. 


            Every 'new year' I put my invoice numbers back to 1, always have done so after 10 years of business I don’t end up with invoice number 37294532.

            It makes everything easier to organize witch is why I would like to be able to do it, just cant work out how to.

            • 3. Re: Resetting invoice number for year end.

              Seems to me that this would make things harder to organize rather than easier. Surely there's a date field on your invoice? So you can group your records by year when it's necessary?

              Is this field used to link invoices to other tables?

              If so, don't do it. It will scramble your data.

              If it's just a data field not used to link to other tables in relationships, open manage | Database | Fields, find the field and double click it to open file options. Select the auto -enter tab and you'll find a place where the next serial value is specified. Set this value back to 1 and your next new invoice will be numbered 1 again.