Differences between Standard and Custom Opportunity Report Types
|Knowledge Article Number||000004564|
A Custom Report Type on Opportunity Object may return a different number of records than a Standard Report Type with the same criteria. The results you get when you run your report are based on a number of Organization-Wide Settings and individual User Permissions. You can resolve the discrepancy by checking the below information.
Territory Management NOT enabled
If the Organization has the Opportunity Organization-wide Defaults set to "Public Read/Only:"
In this Sharing Model, if the owner of the missing Opportunity has a Role at the same level as the Running User, they will need to click on a higher Role.
In an organization with Territory Management enabled a Standard Opportunity report shows different results than an Opportunity Custom Report Type (CRT). This is because the Opportunity CRT Report checks the consistency between Opportunity Owner and Opportunity Territory while the Standard Report does not.
- has "allow forecasting" checked.
then the Opportunity Owner will be automatically added to the Opportunity Territory. (You can test and see this on the User's Territory related list).