cancel
Showing results for 
Search instead for 
Did you mean: 

Invetory Aging Report

Former Member
0 Kudos

Dear sir/madam

I want Inventory stock Aging report like these

Materil 3months >3months to 6 months >6 months to 1 year

zzzz 1000 50000 70000

plz tell me if any Standard T Code are there in Sap otherwise how can i get these report through Z Reports

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

There is no ageing reports in standard SAP.

check the MC46- slow moving items

MC50 for dead stock.

and MC.9 for Mateial and stock analysis

Enter your date range and check weather it is useful or not. If not you need to go for Z-report with help of ABAPer

Answers (4)

Answers (4)

rafael_zaragatzky
Active Contributor
0 Kudos

Just another thought on top of what everybody else wrote. If you don't have batch mgmt, FIFO/LIFO valuation (under the MM menu > Valuation > Balance Sheet Valuation) can be used to track the stock per year, i.e. stock which is less than 1 year old, 1-2 years old, etc.

But I don't have details - it was normally CO people that worked with this functionality.

BR

Raf

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

Logic is below for Zee report.

If the stocks are batch managed:

1. Batch Stock: MCHB_clabs

2. Batch Created date:MCHA_ersda

Take this batch created date and compare with system current date, so that you can get Aging.

If the stocks are not batch managed:

It is difficult to get accurate report in aging.

Former Member
0 Kudos

Dear,

There is no standard aging report which serves your purpose .you have to develop a z-report

former_member529134
Active Contributor
0 Kudos

Hello

ageing reports in std system are MC46 and MC50.

Regards

Former Member
0 Kudos

Hello

>

> ageing reports in std system are MC46 and MC50.

>

>

>

> Regards

Dear Sir

If I want to have a list of item which aging >= 4 years, how can i set in the field?