Skip to Content
author's profile photo Former Member
Former Member

Dynamic Buckets for Stock Ageing Report in BEx Query

Hi All,

I'm looking for the easiest mechanism to create a stock ageing report which has dynamic buckets. The user will run this against a date and will enter the date buckets such as 30, 60, 120, 180, 360 etc.

The easiest mechanism would be to use the offset. However we cannot set a variable for the offset value.

I know that we can use custom exist variables to do this. However i am looking for a best mechanism to do this.

Appreciate your feedback.

Thanks and regards,


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Sep 24, 2014 at 10:10 AM


    first defind the opening and closing stock balance and define the day bukets based on the calay.

    please find the doc…



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.