Best way to deal sequence with deleted records and autogenerated fields.

I’ve got an invoice with an autogenerated number. My client on occasion has deleted the invoice but the autogenerated number is not reset. I’ve had to reset the sequence a few times. Is there a better way to deal with this? Thanks


I’m afraid there’s no better way to reset the auto generated sequence than manual work once it’s jumped. Maybe you could let client resetting under design mode.