Symptom
In the Aging Report applications, such as Accounts Receivable and Accounts Payable, the 'Open on Key Date' prompt field does not allow manual entry or selection of a specific date, only predefined options are available, such as today, last quarter.
Environment
SAP S/4HANA Cloud Public Edition
Cause
The default configuration of the "Open on Key Date" prompt in the Aging Report only supports predefined date options (e.g., today, last quarter).
Resolution
In the 'Manage Date Functions' app, a date function can be created with Date Function Type: Single. This allows entry of a specific date in the 'Aging Report for Accounts Payable'.
Refer to the Manage Date Functions help documentation for further details : Manage Date Functions
However, this method only works for fixed dates. If different dates need to be selected each time the report is run, creating a new date function every time is not practical.
In this case, it is recommended to create a custom analytical query for the Aging Report. This allows to select any key date like 01.01.2025 when running the report.
For more details, refer to the Custom Analytical Queries documentation: Custom Analytical Queries
See Also
Keywords
Analytics, Aging Report, Accounts Payables, Accounts Receivables, date selection, Manage Date Functions, date function, custom analytical query. , KBA , CA-GTF-SB-S4H , Smart Business for S4HANA , Problem