Skip to Content

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

Inventory Ageing report

Hi

We are designing Profit centerwise Inventory Ageing report in BW 3.5.For this we have Ageing periods as 0-60,61-180,181-365,>365 and Non Moving.

We have applied IF-Else Condition in all these ageing period buckets.

The problem with this is that after Materialwise drilldown the overall result is not the same as when we remove the material drilldown.

The result should appear in a single line corresponding to that particular profit center.

We tried After aggregation but still not getting proper results.

Ex. With Drilldown

0-60 61-180 181-365 >365 Non Moving

MAT1 435INR

MAT2 5556INR

MAT3 456INR

MAT4 897INR

Ov.Result 435INR 456INR 5556INR 897INR

Expected results:

Remove Drilldown:

0-60 61-180 181-365 >365 Non Moving

PC1 435INR 456INR 5556INR 897INR

Pls help.

Deepak

Helpful Answer

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