Jan 2, 2020

SAP AP / AR standard Aging reports - out of the box easy

For the ones that have been around in the SAP world for quite some years like me, there has been a constant ask from customers to get an Aging report out of ECC or even S/4 like other systems have. One that would show you Customer / Vendor one-by-one with their total AP/AR and a break it down by due dates for 0-30 days, 31-60, 61-90 and so on ... Many legacy systems have this type of report and it is a must have for any AP or AR Manager to have one. Somehow this has never been the case for SAP to have it out of the box.
You can do something "similar" by using FBL1N for Vendor Line items and FBL5N for Customer line items where you will get document by document with the corresponding due Date or Arrears. But you cannot get buckets like 0,30,60,90, etc. out of it.
In the past, I have seen projects even building these reports in BW (BI later and in today's language Analytics). Another way also, was to have Custom built drill-down report (with Report Painter) to achieve this too, using AP and AR libraries.
But since SAP ECC6.0 EHP5 (and higher of course), the answer to this requirement comes out of the box. It is part of a package of reports and transactions that have been delivered to meet certain legal requirements for China. But who says that you cannot use them for any other country ? They work just fine, have no restrictions and of course they are not written in Chinese (otherwise I would not be able to read them).
The AP/AR Aging report Transaction Codes are IDCNAP and IDCNAR respectively. They are 2 separate Tcodes, but they are almost identical one another. Their principle is just the same. One of the main differences is in the selection screen of the AR Aging report, you can choose / filter by certain SD criteria like Sales Org., Distribution Channel, Division, Sales District and Sales Document.

AP Aging report (IDCNAP)

The report selection screen allows you to run the report by CoCode, Vendor, Profit Center (which for many Companies is important for AR/AP splitting thanks to Document Splitting) and some other indicators. The most important thing, you will find it at the bottom under "Due Date Sorter List". This options are the ones that will allow you to build your own Aging buckets (Ex 0-30, 31-60, 61-90 and so on ...). There is the option of building up to 8 buckets, which is way more than what any normal company would ever need. Once you setup those buckets, you execute it and you will get the data Aging built and split that way.
If you close the Transaction and come back, those bucket will not stay; so that is why I recommend you to build a Selection Variant so you do not have to enter the buckets every time.

AR Aging report (IDCNAR)

This is the AR Aging report with the added option of entering SD Data filtering by SD Organizational Structure criteria.

If you need, you also have "Dynamic Selection" criteria which gives you more selection capabilities.
Once you execute the reports, your output will look like this.

For confidentiality reasons, I am masking the Client Names and other Customer specific data.
Standard, right after execution, it comes with quite a few different subtotals (way to many for me), but it is just a matter of clicking in "Subtotal On/Off" Icon to remove it.
Once done your report will look a lot better.

As you can see you get CoCode, Credit Segment, Profit Center, of course Customer, Reconciliation Account, Total Open item, Amount Not due and then your Aging buckets as per your selection criteria. You also get a percentage calculation of that "bucket" in regards to the grand total, which you can easily remove if you don't like by changing the column layout.

As per extra columns that you can get in the layout, you already get pretty much everything, but you can also add Company Code Name and Credit Control Area.

Once the report out, you can sort up/down, filter anyway you want as with any other SAP report that has an ALV output. You can also do drill-down by double-clicking on any AR/AP bucket and you will get the exact line items that make up that amount.

So as you can see, this is the Aging report that many Customers have been asking for many years and for an unknown reason (at least to me ...), it was never built in SAP out of the box.

As I mentioned, both reports AP/AR are pretty much identical and behave the same. Different program names, but for what I could see in the code, similar program structures underneath.

The reports mention China, but there is nothing specific that will not make them applicable or usable for any other country. I have personally use them already in Canadian and US clients without any issues or limitations.

Where can you find these reports in the SAP Menu ?
They are buried inside the Country specific functions / reports for China in Accounts Payable and Accounts Receivable Menu area.

Accounts Payable Menu


Accounts Receivable Menu


If your Company and/or Project needs to implement this, or any of the functionalities described in my Blog, or advise about them, do not hesitate to reach out to me and I will be happy to provide you my services.

2 comments:

  1. Hi,
    getting dumps while running this report in foreground but its working fine in background,
    we get QL_CAUGHT_RABAX/TSV_TNEW_PAGE_ALLOC_FAILED these dumps in S/4 hana system.Any idea on this?.

    ReplyDelete
    Replies
    1. No idea, I never had any issues running this report in foreground. And definitively never had to run it in background.

      Delete