3657692 - Consolidated Vendor Report with Payment document posted and invoice documents that was cleared by payment doc

• Users are unable to find a standard report in SAP S/4HANA Cloud that displays both the payment document generated during a payment run and the invoices cleared by that payment in a single consolidated view.
• The current report being used only shows the payment document without the corresponding cleared invoice details.

SAP S/4HANA Cloud Public Edition

1. Execute the app "Create incoming invoice".
2. Enter Company Code, Supplier, Invoice Date, and Amount.
3. Post the invoice document.
4. Execute the app "Manage Supplier Line Items".
5. Filter for open items of the Supplier.
6. Confirm that the posted invoice is showing as "Open".
7. Execute the app "Manage Automatic Payments".
8. Enter Run Date and Identification.
9. In the Parameters tab, enter Company Code, Payment Method, and Next Payment Date.
10. Enable logging for payment method and vendor in the Additional Parameters section.
11. Schedule the payment job and wait until the status shows "Payment Finished".
12. Open the scheduled run in "Manage Automatic Payments".
13. Navigate to the Payment List.
14. Click on the line item to get the Payment Document Number.
15. Execute the app "Manage Supplier Line Items".
16. Filter by Supplier and Cleared items.
17. Verify that the invoice is cleared by the payment document.
18. Execute the app "Display Payment Lists".
19. Enter Run Date, Company Code, and other required parameters.
20. Run the report and observe the output.
21. Confirm that the Payment Document is displayed but the cleared invoice is not shown in the output.

No standard SAP report or printable form exists in SAP S/4HANA Cloud Public Edition that combines payment documents and cleared invoices in a single consolidated output.

Possible workarounds:

Below are the other possible methods:

1. Use “Display Line Item Entry” + Export

• Document type KZ (Payment)
• Field: Clearing Document Number
• Then group/export in Excel to link invoices.

To Export to Excel for Better View:

• Go to Display Line Item Entry
• Use Document Type = All, and set filter:
• Clearing Document Number 
• Click Go
• Export the result to Excel 
  • One line for invoice
  • One line for payment
  • Same clearing document field for both

This is the closest workaround to a report showing both together.

2. Custom Form or Custom CDS View

• Create a custom analytical CDS view using:
  • I_JournalEntryItem (includes all documents)
  • Join on fields like Clearing doc and Reference doc
• Build an Embedded Analytics Report or use the Custom Analytical Queries app.

KBA 0002963059 - How to Submit Feature Requests for SAP S/4HANA Cloud Public Edition

payment document, cleared invoices, consolidated report, SAP S/4HANA Cloud, Display Line Item Entry, CDS view, custom analytical query, Manage Automatic Payments, Manage Supplier Line Items, invoice linking, feature request, SAP Customer Influence. , KBA , FI-FIO-AP-2CL , Fiori UI for Accounts Payable (Public Cloud) , Problem