SAP Knowledge Base Article - Public

3094281 - Opportunities Missing in the Report: Opportunity Funnel

Symptom

You find some opportunities missing in the report: Opportunity Funnel.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Go to Design Reports view.
  3. Show All Reports.
  4. Find the report Opportunity Funnel (CRMOPFU_Q0001).
  5. Open the report by clicking on its name.
  6. Filter by Created On.
  7. Apply.

The list of Opportunities displayed is different from the one obtained in the New Business work center - Opportunities view when filtering by the same Created On date.

Cause

The root cause for this behaviour is because the parameter "Calendar Year" in the report corresponds to the Opportunity Forecast Delivery End Date Year.

For exapmle, the created on date of the Opportunity ABC (where ABC stands for the opportunity ID) is in 2021.

  1. Open Opportunity ABC
  2. Navigate to General Tab
  3. You can see Forecast:Delivery Start/End Date is in 2022

This is why if you maintain the "Calendar Year" as 2021, you can't find the Opportunity ABC.

Resolution

You should maintain the expected calendar year in the report.

Keywords

Opportunities, Opportunity Funnel, missing, Calendar Year, Delivery Start/End Date , KBA , SRD-CRM-OPP , Opportunities , Problem

Product

SAP Business ByDesign all versions