Hello !
Not so long ago i've started developping on Odoo Community v14.
I've created a module where projects needs to have unique ID.
Thus, i've added a unique custom sequence number that increments itself each time a project is created by users.
One thing i've noticed is that, each time i upgrade the module, this sequence number is resetted. Problem is the next time a project is created, the user won't be able to save it because the sequence number already exists. I have to manually go to Technical > Sequence and update it to the last number used.
I would have expected it to automatically carry on with the serie.
Is there a way to somehow retrieve the last number used and update it in the sequence number entry ?
What would be the best way to implement this ?
Through database request to grab the last record and add +1 ?
Thanks a lot in advance !