3503157 - Item Total Value Displayed as Zero for the Opportunity Volume Extended Report

The Opportunity Volume Extended Report shows the Item Total Value as zero for the Opportunity Line Item.

SAP Business ByDesign

1. Go to the Business Analytics Work Center.
2. Go into the Design Reports View.
3. Filter for All.
4. Search for the report Opportunity Value Extended (Report ID CRMOPPU01_Q0001).
5. Open the report.
6. On Selection Tab, delete all fields (except Display Currency, which is mandatory).
7. Click on the Additional Filters button.
8. Filter for the Opportunity ID XYZ. (Where XYZ represents the Opportunity ID)
9. Click on Apply.

The Line Item Total Value is shown as zero (0), even though there is an Item Value maintained for it in the Opportunity document.

Opportunity Line Items do not have the "Item Total Value" parameter, but the "Item Value" parameter, which is a different component.

On the report, the "Item Total Value" means the sum of all Opportunity Line Items Value. For this reason, it is zero (0.00) for the Line Items.

If each Line Item value is desired on the report, the "Item Value" Row Field must be added.

On the report, to add the "Item Value" field, follow the below steps:

1. Go to the Business Analytics Work Center.
2. Go into the Design Reports View.
3. Filter for All.
4. Search for the report Opportunity Value Extended (Report ID CRMOPPU01_Q0001).
5. Open the report.
6. Go to the View Tab.
7. On the Row Fields Sub Tab, click the + (plus) simbol to add row.
8. Search for "Item Value" on the search bar.
9. On the Opportunity Item section, mark the displayed Item Value checkbox. 
10. Click Ok.

Now, each Line Item Value is displayed on the report.

item value, opportunity, report, line item, item, zero, not displayed, not shown, byd, volume extended, business analytics , KBA , SRD-CRM-ORD , Orders & Contracts , How To