Solved: How can I have arrivals from global table (in a processflow) ?

amel_b5 · ‎08-30-2022

[ FlexSim 22.2.1 ]

Hello,

I want to realize the reception of products in a warehouse by a processflow based on a reception global table consisting of 4 columns:

1) receiving time (Time)

2) Receiving ID

3) Product

4) Qty

when the reception time "Time" arrives, I want the quantity "Qty" of the product to be created in a reception area ( a floorstorage)

I attach the model of my problem and an image of it

I hope you can support me

Thank you

https://drive.google.com/file/d/1zUrWdSTaGe8aXTx1MUASGryAA_4siWH0/view?usp=sharing

jason_lightfootVL7B4 · ‎08-30-2022

Do you want one token per line or the quantity listed in Qty?

jason_lightfootVL7B4 · ‎08-30-2022

Run this script to put the data in the Source:

string sql="SELECT Time,'arrivaltoken' AS Name,Qty AS Quantity, [Recep ID], SKU FROM Reception";
Table.query(sql).cloneTo(Model.find("Tools/ProcessFlow/ProcessFlow/Source>variables/arrivals"));

jeanette_fullmer88DK3 · ‎09-02-2022

Hi @Amel B5, was Jason Lightfoot's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

How can I have arrivals from global table (in a processflow) ?

How can I have arrivals from global table (in a processflow) ?

Photos