First in First Out for Stock Ageing

[Rajkumar]

Hi All,

 I want to show first in first out logic in stock ageing.

ex. Current SOH is 9. I want to show this 9 split into days bucket 0-30 days, 30 -60 days ....

Here is a sample data .

Date	Stock	Item Code	Location
12/31/2017	2	ABC1	BER
1/2/2018	-1	ABC1	BER
1/9/2018	-1	ABC1	BER
1/17/2018	12	ABC1	BER
2/8/2018	-1	ABC1	BER
2/17/2018	-1	ABC1	BER
2/20/2018	-2	ABC1	BER
3/6/2018	-1	ABC1	BER
3/7/2018	-2	ABC1	BER
3/14/2018	-1	ABC1	BER
3/19/2018	11	ABC1	BER
3/28/2018	-2	ABC1	BER
3/29/2018	-1	ABC1	BER
4/1/2018	-1	ABC1	BER
4/9/2018	-1	ABC1	BER
4/12/2018	-1	ABC1	BER
4/15/2018	-2	ABC1	BER
4/21/2018	-1	ABC1	BER
4/25/2018	3	ABC1	BER