SAP Community Network Forums » SAP Solutions » ERP Financials

Thread: Inventory Ageing report

This question is answered.


Permlink Replies: 4 - Pages: 1 - Last Post: Nov 4, 2009 5:18 AM Last Post By: Sanil K Bhandari
Deepak Agrawal

Posts: 791
Registered: 12/13/08
Forum Points: 436
 
Inventory Ageing report  
Posted: Nov 3, 2009 11:13 AM
Click to report abuse...   Click to reply to this thread Reply
Hi

I require Inventory (raw material) ageing report. Ageing date must be calculated from date of goods receipt.

For example:
I have 100 units of Raw Material A.

Goods receipts date were as follows:

30 units: 1st April 2009
45 units: 1st July 2009
25 units: 1st September 2009

So inventory aging as on 30th September must be:
(days calculated from GR date to 30th Sept)

0 - 30 Days --> 25 units
31 - 60 Days --> 45 units
61 - 90 Days --> 30 units

Let me know TCode from where i can get the inventory ageing as mentioned above or let me know the TCodes / Tables which be helpful for developing report.
Dianne Obviar

Posts: 619
Registered: 11/8/07
Forum Points: 1,098
 
Re: Inventory Ageing report  
Posted: Nov 3, 2009 11:17 AM   in response to: Deepak Agrawal in response to: Deepak Agrawal
Click to report abuse...   Click to reply to this thread Reply
are they batch managed? In our implementation before, we customized an aging report based on batch and the last GR date from table MCH1
Deepak Agrawal

Posts: 791
Registered: 12/13/08
Forum Points: 436
 
Re: Inventory Ageing report  
Posted: Nov 3, 2009 11:18 AM   in response to: Dianne  Obviar in response to: Dianne Obviar
Click to report abuse...   Click to reply to this thread Reply
No.
Batch Management activity is not activated.
kishore babu

Posts: 180
Registered: 12/20/07
Forum Points: 180
 
Re: Inventory Ageing report  
Posted: Nov 3, 2009 11:25 AM   in response to: Deepak Agrawal in response to: Deepak Agrawal
Click to report abuse...   Click to reply to this thread Reply
Hi,

Check teh Standard Reports:

MC.9 - INVCO: Material Analysis Selection, Stock
MC.B - INVCO: Material Analysis Selection, Turnover
MC40 - INVCO: ABC Analysis of Usage Values
MC44 - INVCO:Analysis of Inventory Turnover
MC49 - INVCO: Mean Stock Values
MC50 - INVCO: Analysis of Dead Stock

Regards,

Kishore K

Sanil K Bhandari

Posts: 643
Registered: 3/7/09
Forum Points: 1,128
 
Re: Inventory Ageing report  
Posted: Nov 4, 2009 5:18 AM   in response to: kishore babu in response to: kishore babu
Click to report abuse...   Click to reply to this thread Reply
Hi

Try MCBZ

regards

Sanil Bhandari

Point your RSS reader here for a feed of the latest messages in all forums