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

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

amel_b5
Not applicable
14 Views
3 Replies
Message 1 of 4

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

amel_b5
Not applicable

[ 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


1661893388602.png

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

0 Likes
Accepted solutions (1)
15 Views
3 Replies
Replies (3)
Message 2 of 4

jason_lightfootVL7B4
Autodesk
Autodesk
Do you want one token per line or the quantity listed in Qty?
0 Likes
Message 3 of 4

jason_lightfootVL7B4
Autodesk
Autodesk
Accepted solution

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"));
0 Likes
Message 4 of 4

Jeanette_Fullmer
Community Manager
Community Manager

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.

0 Likes