Inventory reservation with FIFO

tatsuo_oba
Contributor

Inventory reservation with FIFO

Hi experts, I’m now struggling inventory allocation with FIFO algorithm. The requirement is automatic inventory reservation with SKU lot level expiration date as below. Automatic shipment allocation/reservation based on lot # orders using FIFO algorithm is needed. I’m trying a lot of ways using numbered list and many functions or list property, but has not realized. Does anyone has any similar experience and guidance? Best regards, Tatsuo Oba

14 REPLIES 14
tatsuo_oba
Contributor

Thanks, Oleg. It seems to run FIFO calculation simply. I'll email you later about accessing to your workspace. Thank you, Tatsuo Oba
leo_tadjudin_1
Frequent Contributor

Hi Oba san, My solution is similar to Oleg's but more using predefined steps. Although you already have the access to the model, I would still post the screens for everyone's benefit.
BDussault
New Contributor

Hi @leo_tadjudin_1 ! I'm interested in your FIFO solution as well, however your images no longer work. Would you be able to share your model solution with me?

tatsuo_oba
Contributor

Thanks Leo! Really great work.
leo_tadjudin_1
Frequent Contributor

My pleasure 🙂  Glad I could help.