Inventory reservation with FIFO

[tatsuo_oba]

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

[zimin-oleg]

Hi Tatsuo 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

[HendrikDeCuyper]

Hi @zimin-oleg 

Was hoping to pick your brain if you would still have that FIFO logic available to share.

Urgently looking for a solution whilst implementing a Supply Planning use case at a customer.

Thanks!

[zimin-oleg]

Hi @HendrikDeCuyper 

Please see files attached

We've built the solution in 2016 when there were no cumulations across lists
so I believe some constructions could be replaced with new functions

[HendrikDeCuyper]

Hi @zimin-oleg 

Thanks for sharing! 

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.

Kind regards,

Hendrik

[zimin-oleg]

Hi @HendrikDeCuyper 

As I've said there were no Cumulate() functions across the list in 2016

You could use this function and then to Compare Cumulated Stock value across WHs with the Shipment and this will work

[HendrikDeCuyper]

Hi @zimin-oleg ,

Thanks for the quick reply.

I've tried this approach already but then bouncing into a circular reference computing error.

More information on the case I've replied as a comment on this thread: https://community.anaplan.com/t5/Anaplan-Platform/How-to-calculate-within-specific-tenure/m-p/85851/...

Hope you can help!

Thanks

Hendrik

[zimin-oleg]

Hi @HendrikDeCuyper  - attached the blueprint and grid view screen

I've stayed WHs shipment sequence as a variable - but you could also apply the formula

[HendrikDeCuyper]

Hi @zimin-oleg ,

Very grateful for this - managed to make it work, however the caveat still remains to create a formula for the 'Previous Batch/WH' which is tricky. 

Do you have any thoughts on this? 

Thanks!

[zimin-oleg]

Sorry - can't understand the case