Typically, this requires a database repair to properly fix. You can use account ranges and enforce these ranges with a setting in the company profile to prevent this from happening in the future.

Your Adagio Consultant might be able to help you too.