3712135 - Duplicate/missing values occur in the downloaded file in the Clear Outgoing Payments app

When downloading an Excel spreadsheet from the Clear Outgoing Payments - Manual Clearing app, the downloaded file shows duplicate/missing values depending on how the list is sorted within the app.

If the list is sorted by, for example, the Item Text field, the Excel file displays duplicate rows or missing items.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

SAP S/4HANA Cloud Public Edition

1. Open the Clear Outgoing Payments - Manual Clearing app.
2. Select relevant suppliers, line item types, and other criteria for the list.
3. Apply sorting to the list (e.g., by item text) and download the Excel file.
4. Check the downloaded file and observe duplicate or missing values.

Technical limitation.

The development team is currently investigating the issue. More details will be updated later.

As a workaround, adjust the sorting criteria. Use the "Journal Entry" field as one of the sorting criteria, and move it to the last.

For cases involving multiple company codes or spanning multiple fiscal years, ensure that the company code or fiscal year field is included in the sorting criteria.

Duplicate, missing values, downloaded file, Clear Outgoing Payments app, Excel spreadsheet, sorting, Item Text field, suppliers, line item types, criteria, technical limitation, development team, workaround, journal entry field, multiple company codes, multiple fiscal years , KBA , CA-UI5-TBL , SAP UI5 table, smart table, list and tree controls , Problem