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

Question

question

sara S2 asked Feb 24, '20 sara S2 answered Feb 26, '20

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

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

global table

trying1.fsm (117.3 KiB)

· 2

tannerp commented · Feb 25, 2020 at 08:55 PM

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)?

0 ·

understand-binnrb.png (15.6 KiB)

sara S2 tannerp commented · Feb 26, 2020 at 10:58 AM

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".

0 ·

Answer 1 · 2020-02-26T18:15:25Z

sara S2 answered Feb 26, '20

@tanner.p

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

question