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

tatsuo_oba

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

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.

tatsuo_oba

Thanks Leo!
Really great work.

leo_tadjudin_1

My pleasure 🙂 
Glad I could help.

BDussault

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?

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/highlight/false#M18977

 

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