Symptom
You find some opportunities missing in the report: Opportunity Funnel.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Business Analytics work center.
- Go to Design Reports view.
- Show All Reports.
- Find the report Opportunity Funnel (CRMOPFU_Q0001).
- Open the report by clicking on its name.
- Filter by Created On.
- 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.
- Open Opportunity ABC
- Navigate to General Tab
- 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