Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 14, 2008 at 05:19 AM

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

    ageing-report

    Thanks...

    Shambhu

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 14, 2008 at 05:20 AM

    Dear deepak you can check the following lins,

    We have this report based on Batch Manufacturing date..

    Thanks

    Reddy

    Add comment
    10|10000 characters needed characters exceeded