topic Re: How to write the loaded quantity from totes in a global table ? in FlexSim Forum

How to write the loaded quantity from totes in a global table ?

sara_s2 — Mon, 24 Feb 2020 18:57:42 GMT

Hello,

In the attached model, "Operator1" and "Operator2" are loading items (boxes) from "Rack31" and "Rack19" randomly (either "Rack31" or "Rack19"), according to "ProcessFlow2". In the global table "CUDB", we write information about: totes number "BinNrb" (column 3), stock level "StockLevel" (column 5), time of the operation "Time" (column 6) and stock coverage "SC" (column 7) for each item type, using the racks "On Entry" "On Exit" Triggers. When an operator loads items from a rack, the loaded amount of items must be written in the global table "CUDB" column 4, according to from which "StockArea" (column 1) ("rack31" corresponds to "StockArea" number 3 and "rack19" corresponds to "StockArea" number 4) it is loaded.

I tried to do this by custom codes in the processes (“Replenish1” and “Replenish2”) of "ProcessFlow2", or by racks Triggers, but with no result.

Would anyone give me an idea of what I should do, please.

Regards.

trying1.fsm

Re: How to write the loaded quantity from totes in a global table ?

tanner_p — Tue, 25 Feb 2020 20:55:49 GMT

Hi @sara S2,

I understand that you want to write to a Global Table, but I'm trying to understand your process a bit more... What I'm getting is that you want to search the Global Table "CUDB" for values that match an item's label when an operator loads the item and then write a different label value to the table on the corresponding row? For example, if StockArea is "3" and Product is "M1", you would write a value to Row 1 Column 3 of the table "CUDB" (as shown in image)?

Re: How to write the loaded quantity from totes in a global table ?

sara_s2 — Wed, 26 Feb 2020 10:58:52 GMT

We write in column 4 of this table. The other columns are done. In column 4, we write the item loaded quantity. If it is on the “rack31” then we write it in a row that corresponds to “StockArea” 3 and according to the concerned item (M1 or M2 or ....). The same think for "rack19".

Re: How to write the loaded quantity from totes in a global table ?

sara_s2 — Wed, 26 Feb 2020 18:15:25 GMT

@tanner.p

It's ok, I resolve it. Thank you for trying to help me.