RE: Same check for 2 customer's ID
Other thought - first is there a reason for the single customer to have multiple IDs in the system?
Is there a reason for this, or is it due to 'user error' when the order entry people are allowed to enter Customers and don't look very hard and therefore enter extra copies of the same customer?
Reason I ask is we encountered this some time back and we periodically did a Customer ID Cleanup and used the PSTL tools to combine the two or three IDs into a single ID. All records and transactions are combined and nothing is lost.
Let me know what you think of the idea? It works well.