Symptom
CDS view I_JournalEntryItem does not reflect the invoice reference for the final clearing journal entry.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Post one or more partial payments against an invoice using Post Outgoing Payments or Manage Automatic Payments, possibly with deductions (for example, cash discount or tax withholding).
- Complete the settlement so that the invoice becomes fully cleared.
- Open the final clearing journal entry in reporting (for example, via CDS view I_JournalEntryItem or the Journal Entry apps).
- Check the Invoice Reference and allocated amounts for each invoice in the final clearing entry.
- Observe that the invoice reference not available for the final clearing journal.
Cause
This is the Standard system behavior
Resolution
- The Invoice Reference field is populated only for specific document relationships such as partial payments, partial clearings of down payments, credit memos, and subsequent invoices.
- For fully cleared invoices, the Invoice Reference field is generally not populated unless one of these relationships exists.
- The Invoice Reference field can be used to identify related invoice documents where available; however, it does not provide a complete payment-to-invoice allocation history.
See Also
- KBA 2630879 - Clear partial payments and related invoice.
- KBA 3399348 - Partial payment vs residual item.
Keywords
invoice reference, final clearing, clearing journal, partial payment, residual item, cash discount, tds, cds view I_JournalEntryItem, payment allocation, KZ, ZP, outgoing payments, manage automatic payments, invoice-wise breakup, reporting , KBA , FI-FIO-AP-TRA-2CL , Transaction Apps: Public Cloud , Problem
Product
SAP S/4HANA Cloud Public Edition all versions
SAP Knowledge Base Article - Public