Aged Inventory / AR & AP

[Ashali]

Hello,

I am new to SAP, we are using SAP S/4HANA CLOUD 2208.

Need some help in finding out if following reports are available in S/4HANA, if available pls provide report name.

- Accounts Receivable DetailedAging based on Payment Due date with option to use Invoice Date instead of Payment Due Date to calculate ARAging.

- Accounts Payable DetailedAging same options as mentioned above for A/R detailedaging

- Inventory StockAging

If this is not the right forum, pls accept my apologies and direct me to right direction.

Thanks in advance

Ashraf

[JulianoRomanato]

Hello ashraft.

How are you? I have excluded the Tag "SAP S/4HANA Cloud" and included the Tag "SAP S/4HANA Cloud for Finance" for this question, as Accounts Payable and Accounts Receivable are exclusive Topics of Finance Line of Business.

Regards.

Juliano Romanato.

[Ashali]

Thanks Juliano, should I post StockAging as a separate question in some other group?

thanks

[puncovsky]

Hello,

We are currently implementing S/4 Cloud Solution and here is the best FIORI App you can find in regards to A/R and A/P reports

Accounts Payable Overview FIORI APP

Accounts Receivable Overview FIORI APP

Peter Uncovsky

HCL +1 972-800-8749

peteruncovsky@hcl.com

[Ashali]

Thanks Peter, I will check these out. But we do need DetailsWithAging like Inovice# and also option to select Due Date vs Invoice Date.

Regards

Ashraf

[OwenLiu]

We helped you to accept the answer, since there were no updates after 7 days.

You can unaccept it anytime if you have further questions.

[Ernesto_Cepeda · Accepted solution]

Hi Ashraf,

First of all, I wanted to comment that THIS is the forum/community for that type of questions.

In addition to what Juliano and Raman shared I want to share some key Info that might be helpful for the type of info you’re looking for:

- “Aglng Report for Accounts Payable”App – Please find the test script in the Best Practices for Accounts Payable (Scope item J60 - https://rapid.sap.com/bp/scopeitems/J60)

- “AR Aglng Analysis” Card inside the “Accounts Receivable Overview” App - Please find the test script in the Best Practices for Accounts Receivable (Scope item J60 - https://rapid.sap.com/bp/scopeitems/J59)

- “Inventory Analysis Overview” – For inventory is difficult to share a specific report without understanding the exact requirement… but please take a look at the “Physical Inventory – Cycle Counting” (Scope Item 4LU - https://rapid.sap.com/bp/scopeitems/4LU )

Please take a look at the screenshots below taken from an internal SAP system for the 3 suggestions for you to have a look and feel.

I hope this helps.

Ernesto Cepeda

[Ashali · Accepted solution]

Thanks Ernesto, I will review and update.

Ashraf

[Ashali · Accepted solution]

Hi Ernesto,

I have seen the report you mentioned, but these are at Customer & Supplier Level. I am looking for these reports at Invoice level, which tells us how old an individual invoice is?
And for Stock I want to know if StockAging report is available at Part# level?

Thanks

Ashraf

[Ernesto_Cepeda · Accepted solution]

Hello again Ashraf,

I would suggest the use of the following apps to see reports at the invoice level:

Accounts Payable:

- Manage Supplier Line Items

- Supplier Invoices List

Accounts Receivable:

- Manage Customer Line Items

If the pre-delivered apps are not providing the necessary information at the detailed level I would also suggest the creation of a custom report through the use of the “Custom Analytical Queries” App. Both sources are available for Accounts Payable and Accounts Receivable aglng info. Please review the following blog with the info on how to create a custom report: Vendor Report

Similar to the previous custom report, please look at the following link to see how to create a custom report for an Inventory Aglng Report: Inventory Report

I hope this helps.

Ernesto Cepeda

[Raman_Rana]

HI,

Hope you are doing well.

You can refer below link for more information.

Accounts Receivable Overview | SAP Help Portal

SAP Fiori Apps Reference Library (ondemand.com)

Inventory KPI Analysis | SAP Help Portal

regards

Raman Rana

[Ashali]

Thanks, I will check it out.

Ashraf