Customer Aging and Supplier Aging Reports at the Line Item Level using Analytical Query in S/4HANA Cloud, Public Edition

Introduction

Functional consultant or a business key user can effortlessly generate supplier and customer aging reports using the Custom Analytical Queries App for the scenarios outlined below.

Scenario – Accounts Payable Aging:

Your client requires a supplier aging report that displays the aging at different levels: Supplier level, Reconciliation G/L level, Supplier Region level, and Profit Center level. Additionally, they would like the option to access the aging information at the accounting document level in the same report.

Scenario – Accounts Receivable Aging:

Your client requires a customer aging report that displays the aging at different levels: Customer level, Reconciliation G/L level, Customer Region level, and Profit Center level. Additionally, they would like the option to access the aging information at the accounting document level in the same report.

You will have the various other options to select or deselect for your reporting as per your needs.

In this article, we will demonstrate how to create the Supplier Aging report, as described in the “Scenario – Accounts Payable Aging.” The process and steps will remain consistent for other reports, such as “Scenario – Accounts Receivable Aging” or any other reports you wish to generate.

The reports created here will be capable of providing outputs for the following types of aging reports:

1. Aging at the company code with business partner level.
2. Aging at the accounting document with business partner level.
3. Aging at the reconciliation G/L with business partner level.
4. Aging at the profit center level with business partner level.
5. Aging at the region level with business partner.

Report Creation Would Require Following Steps:

• Custom Analytical Queries app:
• Create a custom query by creating the existing most suitable query.
• Field Selection: Incorporate field selections,
• Display: Change field name, field sequencing
• Filter: Set filters as required.
• View Browser app: Create a dedicated app for your custom query.
• Custom Catalog Extensions app: Add your custom app to the appropriate catalog.
• Execute the Custom Report: Utilize your custom report to generate the desired results.

Custom Analytical Queries app

◉ Search with appropriate / most suitable key word(s) as highlighted above:

C_APJRNLENTRITMAGINGGRID: for Supplier Aging

C_ARJRNLENTRITMAGINGGRID: for Customer Aging

◉ Create: Create by copy from an existing suitable query

Copy from C_APJRNLENTRITMAGINGGRID

Click OK, and change the label (Description)

◉ Field Selection: Select and deselect fields in your query

In this query, all fields are already selected; I haven’t chosen or removed any fields. The standard configuration perfectly suits our needs.

◉ Display: Sequence of your fields and rename field name etc.

Here, also we are going with standard. However, you have the capability to change the sequences of the field, change standard field name or hide not required field ‘Measure Structure’ etc.

◉ Filters: User Inputs, Multiple Selection, Mandatory or Optional, Default Values etc.

Company Code: As mandatory selection criteria with a default value

Select a Label (Field) and click on Filter Sign then page on the right-hand side will open

◉ Supplier: As an optional input criterion

◉ Profit Center: As an optional input criterion

◉ Supplier Region: As an optional input criterion

◉ Reconciliation G/L: As an optional input criterion

Likewise, you can put default values for below fields if required. In our example we have not selected anything for below fields, left as standard.

P_KEYDATE

Net Due Interval 1

Net Due Interval 2

Net Due Interval 3

Display Currency

Exchange Rate Type etc.

Once done with filter activities follow as mentioned below

• Click: Save Draft
• Preview: You execute the report and check the result before publishing it. Once satisfied with the result, publish it.
• Click: Publish

View Browser app

Search your query you created earlier and select it.

Click Create Application

We can maintain report name in multiple languages. We have maintained in English and Arabic

Click: OK

Custom Catalog Extensions App

Search your app name

Click on Arrow > / Detail Sign

Click: Add

And search the most suitable: we found below two suitable catalog

Select all the catalog and click: PUBLISH > Click OK

Execute the Custom Report

Use your report and relax

Report Output for Overdue Payable Report & Future Payable Report

Another view

Similarly, you can create report for Scenario – Accounts Receivable Aging.