SAP STOCK AGEING REPORT

[former_member605939]

We have requirement of stock ageing report. Suppose on September 10th there was stock of material XYZ OF 10 pieces with 561 movement.

on 13th of November , we did sales of with movements 601 of 2 pieces,

Can we generate a ageing report that shows 8 pieces of XYZ material in above 60 days and 2 pieces in 0-30 days as input date is 30.11.2021

Not able to find the standard report. Can we do in Z report with partially hit materials. ?

Thanks

[FredericGirod]

with batch management you have several, like BMBC

[sanilbhandari]

Hi

The below blog might be useful

https://blogs.sap.com/2020/06/08/new-inventory-ageing-report/

Thanks & regards

Sanil Bhandari

[former_member605939]

Thanks sir,

Checked the blog. But suppose one material having 4 pcs of stock. and hit with movement 601 on 01.1.2021 for 2 pieces now remaining 2 pieces. is above logic differentiate for 2 pieces for 601 and 2 pieces for balance stock if we input 34.12.2021 with 0 to 30 days and 31 to 60 days...

Thanks.

[former_member605939]

Can any one explain me the stock ageing report.

I have used MB5B & MB51 reports to fetch the data and displayed. Is this the right logic ?

Please update..

[former_member605939]

Hi,

I am facing the issue in Stock ageing report. How it works ? I fetched the closing stock on as on date.

and the get the movement wise details between the given slot dates .

M using Mb5b and mb51 report to get the data. But not getting the exact data.

can any one correct me to get the exact stock ageing report.

How the logic should be ?

Thank You.