Verify inventory of an item Type before pulling all the batch from list

Question

question

Andres Pallaro asked Oct 19, '21 Andres Pallaro commented Oct 20, '21

Verify inventory of an item Type before pulling all the batch from list

Hello,

I am working on a model where I have an station processing products by batches of the same item Type label. It pulls a first item and then, for pulling the missing items of the batch, I have another pull from list with a query referencing the first item Type label.

What I need is a special query on the first pull from list ( on yellow) where, before pulling all of the items of the same label, it verifies if it can fullfill the complete batch, if not it will select another first item with a diferent Type label.

I send the conceptual model.

Batching Pull from list Conceptual Model.fsm

Software Version:

FlexSim 21.2.3

list pull batch processing pull query

1634672078263.png (174.1 KiB)

batching-pull-from-list-conceptual-model.fsm (66.0 KiB)

· 2

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Omar Aguilera Rico commented · Oct 19, 2021 at 11:53 PM

I think this is what you are looking for, if you don't tell me.

batching-pull-from-list-conceptual-model_2.fsm

1 ·

batching-pull-from-list-conceptual-model-2.fsm (74.9 KiB)

Andres Pallaro Omar Aguilera Rico commented · Oct 20, 2021 at 04:36 PM

Thanks Omar!

0 ·

Answer 1 · 2021-10-19T23:49:13Z

Eric M answered Oct 19, '21 Andres Pallaro commented Oct 20, '21

Hi @Andrés Pallaro, here's a model with a few added activities (in green) that make sure there are enough items of a specific type before continuing on with the batching process.

The key here is the custom code activity which runs a query to filter the list by items of the same Type as the first item. The total count is then stored in the label token.itemBatchSize which can be seen in the code below. More information on how to use queries in Flexsim can be found here.

Table Result = Table.query("SELECT * FROM ItemList1 WHERE Type = $1",token.Type);
int Count = Result.numRows; 
token.itemBatchSize = Count + 1; // +1 accounts for first pulled item

The decide activity then checks if there are enough items to batch and the token moves on if there are. If there aren't enough items to fulfil the Capacity, the item is pushed back onto the list and another item is pulled. It's important to note that the Max Wait Timer on the Push to List is greater than 0. This is in case a time comes when there aren't enough items of any type in the storage to fulfil a batch. If it's set to 0, the model will be stuck in a loop pushing and pulling items from the list. Greater than 0 allows the model time to keep moving until more items come into the storage.

Let me know if you have any questions!

batching-pull-from-list-conceptual-model-em.fsm

1634686921936.png (40.4 KiB)

batching-pull-from-list-conceptual-model-em.fsm (69.1 KiB)

· 4

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Andres Pallaro commented · Oct 20, 2021 at 04:47 PM

Thanks for your answer Eric, it seems really concise and efficient!

I have one question when implementing it on the original model. I changed the name of the list to "WIP Pew Horno" and the field to filter by on the list to "tiempoH8". Also the token label is different "tiempoH".

The issue is that it gives me this message.

time: 0.000000 exception: FlexScript exception: No resolved tables at MODEL:/Tools/ProcessFlow/ProcessFlow/Custom Code: Batch Size>variables/codeNode

Am I missing something?

0 ·

Andres Pallaro commented · Oct 20, 2021 at 06:06 PM

I see the image did not send, but here is the original model.

Original Model - Batching pull from list.fsm

0 ·

original-model-batching-pull-from-list.fsm (4.5 MiB)

Eric M Andres Pallaro commented · Oct 20, 2021 at 07:51 PM

Try removing the spaces in the List name.

And then adjusting that in the code:

Table Result = Table.query("SELECT * FROM WIPPreHorno WHERE tiempoH8 = $1",token.tiempoH);

Also, I noticed the way the connectors are on the decide, the Run Carga activity should have a quantity of token.itemBatchSize - 1 instead of token.capacidadHorno - 1

Let me know if that solves the issue you're having.

0 ·

1634759310232.png (4.8 KiB)

Andres Pallaro Eric M commented · Oct 20, 2021 at 10:22 PM

Hi @Eric M , It works now, Thanks a lot!

0 ·

question