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

FIFO_976.png

Accepted answers

All comments

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

2016-10-07_14-15-16_977.png

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

Stock_Blueprint_86379.xls

Scheme_stocks_86379.png

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

Stock_Calcs_86395.png

S1_Stock_results_86395.xls

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

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…