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 |
