NS User
08/06/2025, 9:29 PMRJMNS
08/06/2025, 11:28 PMchristianRILECPQ
08/07/2025, 3:01 AMCASE 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.