Inventory reservation with FIFO

Highlighted
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
Highlighted
Group Leader - Employee

RE: Inventory reservation with FIFO

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
Highlighted
Contributor

Re: RE: Inventory reservation with FIFO

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!

Group Leader - Employee

Re: RE: Inventory reservation with FIFO

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

Highlighted
Contributor

Re: RE: Inventory reservation with FIFO

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

Highlighted
Group Leader - Employee

Re: RE: Inventory reservation with FIFO

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

Highlighted
Contributor

Re: RE: Inventory reservation with FIFO

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

Highlighted
Group Leader - Employee

Re: RE: Inventory reservation with FIFO

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

Highlighted
Contributor

Re: RE: Inventory reservation with FIFO

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!

 

 

 

Highlighted
Group Leader - Employee

Re: RE: Inventory reservation with FIFO

Sorry - can't understand the case