3585697 - Calculation Logic of fields in Cash Collection Tracker - Collections Management

Calculation logic and explanation of the output fields in app Cash Collection Tracker - Collections Management.

SAP S/4HANA Cloud Public Edition

Below is the calculation logic and explanation of the output fields:

Reporting period start and end date are calculated from the 'As of Date' parameter.

• Due in Previous Periods - Due date is lower than the period start date.
• Due in Selected Period - Posting date is lower than the period start date and due date is in reporting period (due_date >= start_date AND due_date <= end_date).
• New Invoices Due - Posting date is in reporting period but no more than As of Date. Due date is in reporting period.
• Total Target = Due in Previous Periods + Due in Selected Period + New Invoices Due.
• Collected - All payment relevant line items (posting key is flagged for use in payment transaction) with posting date in the reporting period but no more than As of Date.
• %Collected - Percentage of Collected with regards to Total Target.
• Outstanding Due - To be collected.

Cash Collection Tracker - Collections Management

Cash Collection Tracker - Collections Management, As of Date, CA-GTF-FXU-FI-AR, FIN-FIO-CCD-COL, Due in Previous Periods, Due in Selected Period, New Invoices Due, Total Target, Collected, %Collected, Outstanding Due , KBA , FIN-FIO-CCD-COL , Fiori-UI for Collections and Dispute Management , CA-GTF-FXU-FI-AR , Fiori FXU Accounts Receivable FI-FIO-AR , How To