SAP Knowledge Base Article - Public

2955535 - "Total" and "Total (Transactional Currency)" Value Mismatch in "Customer Invoice Item [CRMCIVIB]" Data Source Based Report.

Symptom

In some Invoices in a report based on Data Source "Customer Invoice Item [CRMCIVIB]", the "Total" Key Figure shows a negative value, while the "Total (Transactional Currency)" Key Figure has a positive value.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Go to the Design Reports view.
  3. Search for report ABC (ABC represents the Report ID).
  4. Open it.
  5. Filter by Invoice DEF (DEF represents the Invoice ID).

You will see the difference in values between the Key Figures.

Cause

This happens when Cancellation Invoices are being shown in the report. For those Invoices, the "Total" Key Figure includes a negative sign to represent a Cancellation, while the "Total (Transactional Currency)" Key Figure does not have this distinction and shows the value as is displayed in the document.

Resolution

This is the expected system behaviour.

An alternative option may be to check the SAP Business ByDesign Influence Platform to submit an idea.

Keywords

Report, Invoice, Minus, Negative, Mismatch, Incorrect , KBA , AP-CI-CI , Customer Invoice , How To

Product

SAP Business ByDesign all versions