Hello Everyone,
I'm tring to create a logic with the below sample data:
Req O/P: 'Can fill' column
ITEM | Incoming Date | Incoming_Qty | Required | Can fill |
1 | 10/19/2017 | 81 | 126 | 81 |
1 | 11/1/2017 | 122 | | 45 |
1 | 11/1/2017 | 214 | |
1 | 11/9/2017 | 233 | |
I have 126 units required.
i'm getting 81 on one date. So, i can fill only 81 units.
Now, the rem. quantity is 45. This can be filled with the incoming qty on 11/1/2017.
Please see attached application.
Any help is highly appreciated.