I have a multiseller store. I'm creating a seperate seller invoice within series.
My table data is like below
For example if a seller name is John, I ...
In my custom module, I have a database table with auto increment col. The columns values initially work fine but when I delete any record the value increased like this order