Inventory Aging Report in BW 3.5
We are designing inventory aging report wherein we have inventory aging periods as 0-60,61-180,181-365,>365 and Non moving.
The formula to calculate Inventory days is
Inv.days=((Cummulative Inv.Value)/(Avg.consumption for 6months))*30
Depending upon the inv. days we put inv.value in that particular inv. period bucket.
Here when we drilldown materialwise the overall result that we get is correct i.e the inventory value in all the aging periods gets distributed properly.
But when we remove materialwise drilldown the value gets stored
in any of 1 particular bucket and remaing remains zero.
Pls suggest incase what we have to do to get values as it is when we do materialwise drilldown (i.e after and before materialwise drilldown the value should remain the same).
Edited by: Deepak Sutar on Oct 14, 2008 7:15 AM