FIFO concept is first in and first out. "First In" means that "the earliest date" stock is coming in/purchased. "First Out" means that issue/release/send out "the earliest date" stock that is AVAILABLE for that particular item. Available mean > 0.
So, what I guess the logic flow should be:-
1. look for same type of item
2. order/sorting the item purchase date accordingly from the earliest to the latest date.
3. look for the date when the item is available (means item quantity >0)
4. if items available > items out as per step no.3 above, then update the available quantity = quantity available before changes - quantities items out.
5. if step 4 is false (mean items out > items available), then update the available quantity for that row =0, and then continue the action/repeat steps 1, 2, 3, and 4.
I new in Appsheet. Not too sure how to transform the above step into the Appsheet formula/action/bot. I guess this is working as follows the FIFO concept.
Apologize if this didn't work for you. Appreciate it if anyone can try this out by Appsheet language and share it with us if you manage to code/solve it. Thanks.
LinkedIn
Twitter
