Set Slots according to the SKU

Question

question

Larissa R2 asked Apr 24 2020 at 12:52 AM Joerg Vogel edited Sep 02 2020 at 6:27 AM

Set Slots according to the SKU

cenario1-manual_VS5.fsmI am working in a conceptual model of a warehouse. At simulation starts, I upload an initial inventory. During the simulation, In the box 'Storage case Picking' i have placers grabbing items that arrive in a queue and placing them in the racks. However, I would like to implement the following change in my code:

Create Items in the queue1 and set location by the global table 'Alocacoes' (NEED TO BE DONE)
Placer should grab a cart (done)
Insert a pallet on the cart (done)
Acquire 4 or 5 items on the queue (done)
Go to the racks and place the items(I am not sure if the items are being placed in the right slot)

I have 23 SKUs and 960 possible slots. I created a global table called 'Alocacoes' to inform a list of possible slots/addresses to each SKU. So, each SKU has among 42 to 44 slots/addresses to be placed.

When I create a box/item, I would like to check in the table 'Alocacoes' the slot available for that SKU created. Each slot can place 4 boxes. If a slot has 4 box, it needs to be considered full and select the next available address/slot in the list by the SKU.

I am not sure if I was clear enough. I hope you guys can understand me and help me to implement these changes in my simulation.

Software Version:

FlexSim 19.2.3

findslot slots painted slots flexsim 19.2.3

cenario1-manual-vs5.fsm (401.4 KiB)

· 4

Joerg Vogel commented · Apr 24 2020 at 3:56 AM

You know the warehouse demo model? Look for the slot labels in properties of warehousing in the toolbox. And please read about slot labels in manual in the new chapter warehousing.

0 ·

Larissa R2 commented · Apr 27 2020 at 2:09 PM

@Jörg Vogel, thanks for your suggestions.

I read about slot labels in manual as recommended. My model was developed by the warehouse demo model mentioned by you. Although, I still have some doubts.

As mentioned I have a SKU that can be placed in 44 slots/addresses. Actually, in order to assign the acquired Slot to the item, I am using a Custom Code activity. The activity provides two fields to define the Item and Slot respectively, as shown below:

However, I would like to Link an Item to 44 possible slots. Each slot can place 4 boxes. Once the slot has 4 boxes, the next slot that has space should receive that Item.

In the global table 'alocacoes', I already separated the Item with the possibles slots. I don't know how to set this logic in the custom code. Could you please help me? I am new at FlexSim, I am learning as long as I am practicing.

0 ·

1587996554323.png (26.7 KiB)

Joerg Vogel Larissa R2 commented · Apr 27 2020 at 7:19 PM

Your Logic depends alone on the InitialInventory global table. You pull for every row of your table the data wether you need it or not. There are many tokens that never creates items because the quantity value is zero. On the other hand you want to assign slots no more on addresses of a global table, you want to assign slots upon slot.SKU label value and slot.length. It is the amount of assigned items to slot.

You will need actually write or change source code of a query in SQL. @anthony.johnson answered a similar request about how to limit items in slots. The main and important variable is slot in a query.

WHERE slot.length < 5 // test if there are less than 5 items stored or assigned

WHERE slot.SKU = "a text matches" // or number value matches or label of an item

You will write a combination of logical comparisons to get a slot for a slot assignment to a storage item.

Often you find the method hasSpace. This method tests if the dimensions of assigned items fitts into a slot based on the available volume of a slot.

Now back to your request. You have a table that contains addresses for slots matching with SKU text strings in the row header. The header text is already in slot labels called SKU at them in the storage system by the painted slots tool. An item got a label called SKU with a matching text string. Now you are querying for a slot in your storage.system WHERE both labels are matching under the additional condition that there aren't already 4 storage.items assigned to.

0 ·

Larissa R2 Joerg Vogel commented · Apr 30 2020 at 11:18 PM

@Jörg Vogel, I am sorry. But I still didn't get it.

I have the Alocacoes's table, where I say that each SKU can be addressed in 44 different slots, since the

slot.length < 5

I don't know how to program my simulation to understand that the SKU = 'DESINF.PO BRIL.ANT.16X1KG SC' can be placed in Z1-A1-1-1-1 or Z1-A1-1-1-2 or Z1-A1-1-1-3.... (44 slots as an option)

So, in my process flow, in the 'storage case picking', when I create an Item, I would like to have 44 possibles addresses for that Item.

Hence, on Find Slot, I already have the query: (WHERE slot.slotItems.length < 4), I also need to inform the 44 possibles addresses fo each Item according to the global table Alocacoes.

I don't know how to program the query 2 with this logic. Could you please help me? Is it clear? I am sorry about my English

0 ·

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2020-05-01T12:31:20Z

Joerg Vogel answered May 01 2020 at 12:31 PM Joerg Vogel commented May 01 2020 at 12:49 PM

@Larissa R2, here is an example model. I painted the slots of the first bay of each rack with a label. The label value is a string. My strings are "red","white","blue" and "yellow". I find a slot for a token with the clause:

"WHERE slot.slotItems.length < 2 AND SKU = $1",0,token.mySKU

token.mySKU stores a random chosen value of my color string names.

I create a box in model.

The color is assigned by executing a string:

executestring("Color."+token.mySKU)

Then I transfer the slot data from the token to the item converted as storage system data.

Storage.Item myStorageItem = Storage.Item(token.item);
myStorageItem.assignedSlot = token.mySlot.as(Storage.Slot);

I have just limited space in my rack, not by hasSpace method but through my clause. If there isn't a slot assigned to token label, I divert the created boxes into a queue.

Then I need the rack object as a destination for my move object activity.

token.mySlot.as(Storage.Slot).storageObject

Slot heights are too low to fit all assigned boxes in them, but that is what I wanted to show, that you can limit the slot content and assign by a label value completely independent from any address.

findSlot_slotlabel.fsm

slot-by-label-pf.png (122.3 KiB)

findslot-slotlabel.fsm (38.5 KiB)

· 1

question