Symptom
The Invoice Volume Report displays three Invoiced Net Value key figures. Only one key figure shows the correct value, while the other two display incorrect values.
Environment
SAP Business ByDesign
Reproducing the Issue
- Navigate to the Customer Invoicing work center.
- Select the Reports view.
- Search for and open the Invoice Volume Report.
- In the Selection, search for the invoice ABC (ABC represents the Invoice ID).
- Observe the Invoiced Net Value key figures.
Three Invoiced Net Value key figures are displayed. Only one key figure shows the correct value, while the other two display incorrect values.
Cause
- Navigate to the Business Analytics work center.
- Select the Design Reports view.
- Search for and open the Invoice Volume Report.
- Click Configure and select Add Fields.
- Navigate to the Key Figure tab.
- Expand the Key Figures section.
- Observe that there are two key figures with the same name, "Invoiced Net Value," and both are selected.
The Invoice Volume Report was configured with duplicate Invoiced Net Value key figures. Two additional key figures with the same name were selected in the Report: Invoice Volume - Report opened by Administrator in Business Analytics work center.
As a result, the report displays three Invoiced Net Value columns instead of the required one. Since the duplicate key figures have different underlying calculations, they display incorrect values.
Resolution
- Navigate to the Business Analytics work center.
- Open the Design Reports view.
- Search for and open the Invoice Volume Report.
- Click Configure and select Add Fields.
- Navigate to the Key Figure tab.
- Expand the Key Figures section.
- Identify the two duplicate Invoiced Net Value key figures.
- Unselect both duplicate Invoiced Net Value key figures.
- Click OK.
Verify the Invoice Volume Report. Only one Invoiced Net Value key figure should be displayed with the correct value.
Keywords
Invoice Volume Report; Invoiced Net Value; Duplicate Key Figures; Business Analytics; Report; Key Figure; Incorrect Value; Customer Invoicing , KBA , AP-CI-CI , Customer Invoice , Problem
SAP Knowledge Base Article - Public