Symptom
The Data Source "Purchase Order Item Details with Follow on Documents" shows positive Invoiced values from voided or unposted Supplier Invoices.
Environment
SAP Business ByDesign
Reproducing the Issue
WoC Business Analytics
Design Data Sources view
Search Data Source ID *SRMPO_B12* (Purchase Order Item Details with Follow on Documents) and click Preview.
Now maintain a Purchase Order ID and run the report.
When looking at the column "Invoiced Values In Company Currencies", you might notice that the system has added to the total, some Supplier Invoices that have not yet been posted or that have been Voided.
Cause
This is the expected system behavior.
Only the Supplier Invoices that have been canceled will not been added to the total of "Invoiced Values In Company Currencies".
In this case, the Canceled Supplier Invoices will be shown on the Data Source with a negative value.
Resolution
In order to accurately run this Data Source, you need to specify under "Status of Supplier Invoice" field, which is the needed status (Ex: Posted).
By doing so, you will automatically reject any voided or unposted Supplier Invoice from the report.
Keywords
SRMPO_B12, Purchase Order Item Details with Follow on Documents shows Voided Values, Voided Status, Unposted Status , KBA , AP-SIP-ANA , Analytics , How To