Skip to Content
0

SAP Bex Stock Ageing Bucket Calculation

Nov 21, 2017 at 07:47 AM

37

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Loed Despuig Dec 01, 2017 at 02:12 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
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

0

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)
0
avatar image
Former Member Dec 19, 2017 at 10:09 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded