Sage X3 allows a parameter to warn user for duplicate values in BPRVCR.
How can this warning be change to an error?
Then I guess, this is a development for your customer, you should ask developer to create such control .