Hi I am trying model a drive in rack logic where the item is placed in rack first by matching label such as SKU then followed by first available level. Once level is filled, then the item will go back to the lowest bay and go up by level again.
I managed to control the assigned level, but it is not dynamic enough for the first available level. Any idea to do this?
enclosed is the model that I have done.
I thought that In your query you are referencing SKU without the slot and for this to work you should add SKU as an indexed label in the Storage System GUI or use slot.SKU.
Now - you have a rack that doesn't have the SKU label on its slots, so if you search for a slot in the storage system those slots will now complain that they don't have that label - so if you want to use slot.SKU it must be allow nulls by adding the '?' - so slot.SKU?
Also based on your description you should be able to just order by level and bay in order to fill as you described, so then the query is just:
WHERE slot.SKU? = $1.SKU AND slot.hasSpace($1) ORDER BY slot.levelID ASC, slot.bayID ASC
However, it turns out that you can just use SKU without adding it to the Storage System labels and that still works but gives a different result. I think I need to report this.
1. The SKU on rack was assigned using "Paint Slot Labels".
2. I have implemented what you have suggested to Query in the Find Slot activity. It did not work out. I would like the item to fill the next level instead of filling that slot at the same level first.
David
Okay then try changing the order by to this:
ORDER BY slot.slotItems.length ASC, slot.bayID ASC, slot.levelID ASC
which should give you this:
Thanks.
It still looks strange as the item is not filling up one rack till full before going to the next rack. I think query statement get it to find a slot with the shortest in length in all storage system.
David
It works only with ORDER BY slot.slotItems.length ASC
16 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
