Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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