Find Duplication in Customer Master

A Customer could have several branches with the same name, so you will need to compare a couple of fields Name and (Zip) Post Code are the most likely choices these need to be well formed and same case to find duplicates.

Quick Solution:
Create a buffer table with fields 'No.' Code 20, 'Name' Text 50,'Search Name' Code 50, 'Post Code' Code 20, 'Matches' Integer

Primary Key = 'No.'
Secondary Key = 'Search Name', 'Post Code'

The field Matches is a flowfield with Count of Buffer Table where 'Search Name' = 'Search Name' and 'Post Code' = 'Post Code'

Create a report on the Customer table to populate the buffer table and a global record variable for the buffer table.
Empty the buffer table if running more than once.

Customer data Item OnAfterGetRecord

BufferTable.INIT;
BufferTable."No." := "No.";
BufferTable.Name := Name;
//Strip out all spaces and other chars that could mess up the compare
//J & V v.o.s. Search Name becomes JVVOS for matching
BufferTable."Search Name" := UPPERCASE(DELCHR(Name,'=',' +"&/,.;:-_(){}#!£$\'));
//CZ-696 42 Post Code becomes CZ69642 for matching
BufferTable."Post Code" := UPPERCASE(DELCHR("Post Code",'=',' +"&/,.;:-_(){}#!£$\'));
BufferTable.INSERT;

Now you can create a form or report and filter on Matches <> 1

This simple code segment is based on the the Contact Management codeunit 5060 DuplicateManagement, so if all Customers are Contacts then you already have the tools to find duplicate Contacts.

David

check the MArketing Module. There is a Duplicate Function for Contacts.
It's descri. in the Onleine Help how to setup and it'S also descr. in the Marketing PDF.

But this Duplicate function is only for Contacts and not directly for customers.
Also it's not the fastes ;-). As i sai, check these Grandule before ....

REgards

Please no problem and welcome