question

Amel B5 avatar image
0 Likes"
Amel B5 asked Jeanette F commented

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

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

FlexSim 22.2.1
processflowglobal tablesourcewarehouse
1661893388602.png (55.9 KiB)
· 2
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image Jason Lightfoot ♦ commented ·
Do you want one token per line or the quantity listed in Qty?
0 Likes 0 ·
Jeanette F avatar image Jeanette F ♦♦ commented ·

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 0 ·

1 Answer

·
Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered

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"));
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.