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