Skip to Content
0
Former Member
Feb 17, 2009 at 11:51 AM

Stock Ageing Report

319 Views

Dear Friends,

We want to develop a report on stock ageing especially for below material Types:

1) Dyes & Chemicals

2) Spares & Consumable

3) Packing Material

All the above Types are not Batch Managed. Now without batch management is it possible to have a correct

stock age report.

Input in our report is

Plant (Mandatory)

Material Type (MARA - MTART) (mandatory)

Material (MATNR)

Material Group (MAKTL)

Ageing Date (Current Date)

In Output we require

Material, Material Type, Material Group, Plant, Valaution type, UOM, Total Stock, Total Stock Value,

Then the bucket

0-30 (Qnty & Value) , 31-60 (Qnty & Value) 61-90 (Qnty & Value) 91-180 (Qnty & Value) 181-365(Qnty & Value) 365 & above(Qnty & Value)

This is what we have planned.

Can any one suggest some ideas or logic how we can go about it.

Thanks & Regards,

Karthik