use the technological process to establish a table monitoring

[a25983579]

[ FlexSim 19.0.0 ]

There are 5 kinds of products. I want to use process flow to create a detection product type and quantity feedback to a table, and when the same product is produced, it will be updated in the original quantity, and when the product is transferred, it will also be in the quantity. Make corresponding updates on

訂單清單.fsm

[moehlmann_fe · Accepted solution]

If you want to store the quantity directly in the list you push the items (tokens) to, you can use an expression field. In the attached example I use an SQL query to count the rows with the same type and return that number as the field value.

You can also use a global table. By using numbers, rather than letters to identify the types you can have one row correlate to each type and simply increment/decrement the quantity value in various triggers. This is demonstrated on Queue1 in the attached model.

order-list_1.fsm

[a25983579]

Ok i got it

Then I would like to ask, if I want to create an order to be displayed and the entire system will pick up the order according to the order, how should this be handled?

order list.fsm

[moehlmann_fe]

Push the items to a list, then the order token can pull the needed amount from it and release the items from the racks. The racks should be set to "Do Not Release Items", so they store the items until they are needed.

order-list(1).fsm

[a25983579]

The last question, is there a way to write the order information of the list into the table?

And after completing the order, change the "status" value in the table from 0 to 1?

[moehlmann_fe]

After the respective labels are assigned to the token use a custom code activity (Data -> Add Row and Data to Global Table) to write the data to the table.

By using a "Wait for Event" activity in the subflow that listens to the respective item entering the output queue, you can delay the main token until all items of an order have been transported to the queue. Afterwards the main token can update the table cell value. (custom code activity -> Data -> Write to GlobalTable)

order-list2.fsm

Make sure to reset the order table between runs. (Reset trigger in properties -> Delete all rows)

[a25983579]

Thank you, these are very helpful to me!!