(sorry to post it again. i missed to put the previous post as question type. couldn'te reward points)
Hei has any one worked in the below or a similar requirement. What is aging.
What does inventory aging by stock type mean? Plz help
any code...any ideas would be good.
Create a new inventory aging by stock type update program and report program.
A new inventory aging by stock type update program will extract the data in table LQUA and populate the new aging table according to the key fields.
Extract the record and place them into 7 aging intervals after the calculation: 130,3160,6190, 91120, 121150, 151180, over 181 days.
To calculate aging use the GR data(WDATU) inLQUA field as base and calculate the aging up to today.
use total stock(LQUA-GESME) for stock on-hand qty.
use the moving average price(MBEW-VERPR) to calculate stock value.
REference MARA-MATKL to obtain material group of a material.