Symptom
Total invoice value showing on report Invoices with Exceptions is not the same as the value shown on the actual invoice.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Supplier Invoicing work center.
- Go to Reports view.
- Search for report Invoices with Exceptions.
- Open it.
- Fill the necessary data to find your Supplier Invoice ABC (ABC is the invoice's ID).
- Click in Apply.
You can see that the total value for ABC is XYZ (XYZ is the total value of the invoice).
However if you open invoice ABC, the total value is actually PQR (PQR is a value that is different from XYZ). So the value in the report is wrong.
Cause
This scenario is a known limitation owing to the design of the underlying data source and report. There involves a significant effort which cannot be fixed as a bug.
Resolution
You can join the data sources Supplier Invoice Item Details (SRMIV_B03) and Invoice Exceptions (SRMIX_U01) to create a report to meet your requirements. Then you can get the data of invoice value and exception information as expected.
Keywords
Supplier invoice; Exception; Report; Data Source , KBA , SRD-SRM-SI , Supplier Invoicing , How To