AnsweredAssumed Answered

Insert missing serial number record?

Question asked by gpgrieco on Jun 20, 2012
Latest reply on Jun 20, 2012 by philmodjunk

Title

Insert missing serial number record?

Post

I have a table for invoices. Instead of marking an invoice as void, I would rather delete the invoice, but this would leave a gap in the invoice ID's. Is there any way of inserting a record with the missing serial number field? So lets say I have invoice 1-100, and number 57 is missing, can I have a script to create a record without interfering with future serial numbers that are created?

Outcomes