In Salesforce CRM, reports may display duplicate Account or Contact records when the report includes a Territory field as a column, grouping, or filter. This behavior occurs because Standard Report Types and Custom Report Types handle Territory fields differently.
For example, in a standard "Contacts and Accounts" report:
As a result, a single Account or Contact record may appear multiple times in the report output.
To prevent duplicate records from appearing in the report, use one of the following approaches:
Option 1 — Remove Territory fields from the report
Remove all Territory field columns, groupings, and filters from the report. When no Territory field is present, the report reverts to the standard "Contacts with Accounts" behavior and each record appears only once.
Option 2 — Use a Custom Report Type
Create a Custom Report Type that does not include Territory relationships. Reports based on Custom Report Types do not apply the Territory-based join logic that causes duplication in Standard Report Types.
Either option prevents duplication and displays each Account or Contact record only once in the report.
000383525

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.