SAP Bex Stock Ageing Bucket Calculation

[Former Member]

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

[Former Member]

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

[Loed]

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

[Former Member]

Hi Loed,

There are Stock Ageing Report created using Batch management. Using Batch creation date we define offset at Bex. But my client doesn't use Batch management and hence i created a report with just simple logic Receipts-Issues. There are negative values displayed in the report after implementing this logic but i do not want to display Ageing Buckets with negative signs.

I have defined the report as Receipts (0RECVALSTCK) & Issues(0ISSVALSTCK) using offset for different ageing buckets, Bucket 0-7 Days (Receipts- Issues) and so on.

Could you pls. let me know how to remove the negative signs and just display the positive stocks for each ageing buckets?

Or suggest me how to create the Stock Ageing Report .

Regards,Saranya

[Loed]

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