I need to create a complex duplicate check rule.  I am familiar with the aggregation rule; however, in this case it won’t work for me.  Here is the logic to determine duplicates:

If the name, unit of measure, location, and type are all the SAME but the code (not a PK) is DIFFERENT then it is considered a duplicate.

These would be considered duplicates:

This is not considered a duplicate because we can extend products to different locations instead of creating a new row:

When I write the rule, I use the aggregation rule to select name, uom, location type is not unique; however, that can give me false positives for the scenario above (Code = 678).  I don’t see a way to say these fields are the same while this field is different.  I am doing this in one web; however, I’m open to writing something in the desktop if there is a way to do this.  Any help would be appreciated.