topic How can i find Stock Ageing for this scenario in App Development

How can i find Stock Ageing for this scenario

subathra — Fri, 02 Dec 2016 06:43:08 GMT

Item, Branch , Date ,In_Qty ,Out_Qty ,Stock_Qty

ABC, 0A1, 1/1/2016, 10, 0, 10

ABC, 0A1, 4/1/2016, 0, 8, -8

ABC, 0A1, 23/2/2016, 10, 4, 6

ABC, 0A1, 28/2/2016, 0, 2 , -2

Re: How can i find Stock Ageing for this scenario

Gysbert_Wassenaar — Fri, 02 Dec 2016 07:00:11 GMT

Subtract the date of entry of the stock from the current date.

Or perhaps this example can help you: SAP Stock Aging using the MSEG and MKPF tables

Re: How can i find Stock Ageing for this scenario

sushil353 — Fri, 02 Dec 2016 07:05:03 GMT

Try this:

load Today()-Date(Date#(Date,'DD/MM/YYYY')) as AgeingDays,* inline

[

Item, Branch , Date ,In_Qty ,Out_Qty ,Stock_Qty

ABC, 0A1, 1/1/2016, 10, 0, 10

ABC, 0A1, 4/1/2016, 0, 8, -8

ABC, 0A1, 23/2/2016, 10, 4, 6

ABC, 0A1, 28/2/2016, 0, 2 , -2

];

HTH

Sushil