I have around 50,000 account records in Salesforce, and I need to identify and display a list of duplicate accounts based on the Company_Name__c field. Specifically, if more than one account has the same value in this field, those accounts should be considered duplicates.
I initially attempted to achieve this through a Screen Flow, but I'm running into errors due to the large number of records being processed and report is also not working.
Can anyone suggest a more efficient approach or solution to handle this task, especially considering the volume of records?
You should set up matching rules in setup which determine how duplicates are matched, and then setup duplicate rules which determine what to do with these duplicates found. To report on the duplicates found, you should create a custom report type: go to setup --> Report Types --> New Custom Report Types --> then use the 'Duplicate Record Sets' as the primary object
