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

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.

SAP Business ByDesign

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.

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.

This behaviour is same for Net Value (Transactional Currency)

This is the expected system behaviour.

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

Report, Invoice, Minus, Negative, Mismatch, Incorrect, Positive; positive value; currency positive; , KBA , AP-CI-CI , Customer Invoice , How To