Skip to Content
avatar image
Former Member

SAP Bex Stock Ageing Bucket Calculation

Hi Experts,

I have read many blogs & discussions on calculating the Stock Ageing Buckets but couldn't find a resolution for my issue.

Created a Stock ageing report which displays Total Stock, Total Value, Ageing buckets(0-7 Days, 8-15 Days, 16-30 days and so on ) for Quantity & value.Defined Total Stock as 0VALSTCKQTY with calendar day restriction. We need to display the Stock report based on the key date entered by the user. Also defined the Ageing buckets as RECEIPTS - ISSUES with calendar day offset.

The report displays negative quantities in different ageing buckets but users want the buckets should be in positive quantities. Also the sum of ageing buckets should match with Total Stock.

Kindly advise on how to define the ageing bucket in Bex query in a simpler form without any batch date inclusion.

Thanks & Regards,

Saranya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 01, 2017 at 02:12 AM

    Hi,

    What do you mean by "without any batch date inclusion"?

    What did you do so far? Can you show it so we may suggest what you need to revise or add in your existing query?

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      You may do an IF statement to your keyfigure with NEGATIVE values. Let's say your KF is KF_FINAL.

      This will be your formula:

      FORMULA = ( KF_FINAL >= 0 ) * KF_FINAL

      Then in your query properties, just suppress ZERO in ROWS.

      Regards,

      Loed

      delete.jpg (66.7 kB)
  • avatar image
    Former Member
    Dec 19, 2017 at 10:09 AM

    Issue has been fixed by writing logic on Receipts & Issues.

    Add comment
    10|10000 characters needed characters exceeded