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:
- Aging at the company code with business partner level.
- Aging at the accounting document with business partner level.
- Aging at the reconciliation G/L with business partner level.
- Aging at the profit center level with business partner level.
- 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.
- Create a custom query by creating the existing most suitable query.
- 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.
