Hi, Is there a way to pull in the customers list t...
# suiteflow
n
Hi, Is there a way to pull in the customers list those have same customer IDs? This is to identify the duplicate customers with the same ID. We have some customers with the same customer ID.
r
Customer search 1. Field 1 - Customer ID - Group 2. Field 2 - Internal ID - Count 3. Summary criteria - count of Internal ID > 1
🙏 1
c
Yeah, duplicate customer IDs are a pain. You can find them with a saved search pretty easily: Go to Lists > Search > Saved Searches > New Set criteria to Customer and add a formula field like:
CASE WHEN {internalid} != MIN({internalid}) OVER (PARTITION BY {entityid}) THEN 1 ELSE 0 END
Or simpler approach: export all customers to CSV and use Excel to find duplicates by sorting on the Customer ID column. The real question is how you got dupes in the first place cos NetSuite usually prevents this. You might have import issues or custom scripts bypassing validation.