I have a requirement to have the sequence number from 1 to 10000 once it reaches 10000 this value NextID should be reset back to 1. I tried using designer process to reset the value it is giving permission denied error.
Is there a way to reset the limit once it reaches the set limit?