3639439 - Discrepancy in Net Due date between Manage Customer Line Items app and Aging Report in SAP S/4HANA Cloud Public Edition

• A discrepancy is observed in the Net Due Date displayed for a customer line item in Manage Customer Line Items and Aging Report or custom analytical queries.

SAP S/4HANA Cloud Public Edition

1. Open the Manage Customer Line Items app.
2. Search for the journal entry.
3. Note the Net Due Date displayed in the app.
4. Open the Aging Report or custom analytical query.
5. Compare the Net Due Date for the same customer and journal entry in the query.

• The discrepancy arises due to the differing logic between the Manage Customer Line Items app and the analytical query. The app Manage Customer Line Items displays individual line items, whereas the analytical query categorizes payments and invoices under the same aging bucket for accurate reporting.

1. Understand that this behavior is by design.
2. The analytical query ensures that payments with an invoice reference are categorized under the same aging bucket as the referenced invoice.
3. In this case, the Net Due Date from the referenced line item is applied to the payment line item.

• Customer Aging and Supplier Aging Reports at the Line Item Level using Analytical Query in S/4HANA Cloud, Public Edition
• G/L Perspective of AR Aging Grid - Query

net due date discrepancy, manage customer line items app, custom analytical query, C_ARAGINGGRIDGENLEDGERQRY, I_ARAGINGGRIDGENLEDGERCUBE, aging bucket logic, s/4hana cloud, reporting apps, payment line item, invoice reference, analytical query behavior. , KBA , FI-FIO-AR-IS-2CL , Reporting Apps: Public Cloud , Problem