SAP Knowledge Base Article - Public

3612154 - Unable to Select Specific Date in Aging Report for Accounts Payable App

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

Creating Dynamic Date filter using the Manage Date Function App

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

Product

SAP S/4HANA Cloud Public Edition all versions