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
Reproducing the Issue
- Go to the Business Analytics work center.
- Go to the Design Reports view.
- Search for report ABC (ABC represents the Report ID).
- Open it.
- 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 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 , KBA , AP-CI-CI , Customer Invoice , How To