Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Inventory Aging Report in BW 3.5

Hi

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).

Pls. help.

Thanks.

Deepak

Edited by: Deepak Sutar on Oct 14, 2008 7:15 AM

Not what you were looking for? View more on this topic or Ask a question