It would be really useful if there was a business rule I could activate to prevent new banks from being set up with the same sort code as an existing bank.

Thinking about it, this is partly an Import-Omatic issue, since if I was splitting up a gift file into separate imports and adding banks separately through RE Import, only the new ones would make it through and the rest would be exceptions (I think).

However, I still think it would be a useful option within RE.

Although IOM has the option not to add new banks to the bank table at all, this isn't practical for us as there are many instances where we do want to add the new bank. We only don't want to add it if it already exists, because duplicates are a pain.

(This isn't an issue when adding banks manually, as you can search by sort code to see if it already exists, but the vast majority of our banks are added through imports.)