Wrong membership ID for new members

Thanks Tuan,
The basics of this is Ok and I have succesfuly repaired the 'invoce-numbers table'.
There was I typo in it, so if anyone else like to do something like this, the right query is:
UPDATE #_osmembership_subscribers SET invoice_number = invoice_number - 2020000 WHERE invoice_number > 20200000;

Problem solved!

Great. Thanks for the update Nico and happy to hear that the issue is sorted

Tuan