cancel
Showing results for 
Search instead for 
Did you mean: 

Inventory Aging Report in BW 3.5

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member181964
Active Contributor
0 Kudos

Dear deepak you can check the following lins,

We have this report based on Batch Manufacturing date..

Thanks

Reddy

Former Member
0 Kudos

I'll suggest you to go through below thredas....lotz of discussions are there on this:

Thanks...

Shambhu