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
We did smth simlar for POC model (please see the screenshot attached)
The solution is easy but it uses 5 modules so may be would be better to give you temporary access to my model
And it's just a piece of POC model - we had to build a bit more complicated solution for customer application
Unfortunately the logic requires that there is a predefined amount of items to be ranked, e.g 4 warehouses in your example.
The use case I'm working on can range from 1 to 100 batches where the product will consume from, I'm rather looking for an iterative way of setting it up instead of building the logic sequentially with 100+ line items.