suddendly I have 3 times 2 invoices with the same number without changing anything?

[deech123]

Hi guys,

I have done my work for the accountant and suddenly I see that on 2 days I had problems with the invoice numbers.
I have 3 times 2 invoices with the same invoice number???

they are made on different days, I didn't change anything of invoicenumber or whatever, so any idea?
with over 300 invoices per month this can not be go wrong.

this is an overvieuw:

orderid invoicenumber invoicedate
--------------------------------------------------
192 154 02/12/2010 14:41:01
194 154 02/12/2010 10:18:38

196 155 03/12/2010 11:12:30
189 155 02/12/2010 11:10:14

191 156 02/12/2010 10:20:26
201 156 03/12/2010 11:12:26

so you see totaly different timestamps.

wouldn't it be beter to add an extra control. before you write a new invoice number that you check if this number allready exist in the db before really adding it?

any idea what could went wrong?

thanks for any tip or clue