cancel
Showing results for 
Search instead for 
Did you mean: 

Aging Stock Report - Logic

Former Member
0 Kudos

Dear All,

Anybody can share the Logic/Functional spec for developing the Stock Aging Report based on the receipt for the current stock which is available in trading plant.

Thank You,

Mani.

Accepted Solutions (0)

Answers (1)

Answers (1)

BijayBarik
Active Contributor
0 Kudos

Hi,

The Stock Aging Report displays the description of material that are stocked for n-number of periods at particular inventory locations( may be trading plant or manufacturing Plant). The details, which are displayed, are about the aging period for the selected items.

There are reports and T code are

MC.A ,

MC.9,

MM5B,

MMBE,

MB5M,

MC50 - Dead Stock ,

MC46 - Slow-moving items,

If the above reports not meet your requirement, you should develop your own ABAP program to meet your specific business requirement.

Regards,

Biju K

Former Member
0 Kudos

Dear Biju,

Thanks for your response.

But our requirement is we should know the current stock Age, for example like current stock should cater into 30 days, 60 Days, 90 Days, 120 Days.

Any idea for bringing this logic,

Anybody have done this type reports?

Tks

Mani.

BijayBarik
Active Contributor
0 Kudos

Hi,

***Logic behind ***

This is define in overall stock on value based, suppose a material is received in Feb-month, same material is received in Jan-2007 , DEC-2007 also.The total value of this inventory is say 90 lakhs, ( 30 lakhs of each month) so system will show inventory aging as below

stock aging less than 30 days, 90 lakhs

stock aging more than 30 days but below 60 days 60 lakhs

stock ageing more than 60 days but below 90 days 30 lakhs

Assuming that no issue taken place if issue is taken place, it will be deducted by default FIFO method. You may have to develop an ABAP report.

Regards,

Biju K

Former Member
0 Kudos

Dear Biju,

We are using Serial Numbers for the Material, so the stock aging cannot be caluculated based on the FIFO Method.

Could you know, how to take the Goods Receipt Number based on the Serial Number.

Tks

Mani