Resetting invoice number for year end.
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!