Controlling the product quantity leaving multiple warehouses
Posted: Friday 03 February, 2017 - 12:24
Hello,
I face the following problem:
We have 4 products. We produce 100 from the first one , 90 from the second, 60 from the third one and 30 from the fourth. The products are strored in the warehouse. We want to control how many products will leave each warehouse and will be led to the sink.
I have writen this 4d script code in the TriggeronExit field of each warehouse:
Do(
var[(valRow), vbValue],
valRow := Label ([SourceNrContainer]),
loopUntil(
Cell(valRow,11,refProductionDetails) = Cell(valRow,1,refProductionDetails),
Cell(ValRow,11,refProductionDetails :=Cell(valRow,11, refProductionDetails)+1)
)
I have a table named ProductionDetails. 11th column is a counter on the exit of each warehouse. The quantity that we want to leave each warehouse is shown in the first column of the table. We want when the desired quantity is reached by the counter the forklift to move to the next warehouse and do the same.
I attach you a very very simpler model in order to show you what i have in my mind.
Thank you a lot.
With respect,
Vassilis
I face the following problem:
We have 4 products. We produce 100 from the first one , 90 from the second, 60 from the third one and 30 from the fourth. The products are strored in the warehouse. We want to control how many products will leave each warehouse and will be led to the sink.
I have writen this 4d script code in the TriggeronExit field of each warehouse:
Do(
var[(valRow), vbValue],
valRow := Label ([SourceNrContainer]),
loopUntil(
Cell(valRow,11,refProductionDetails) = Cell(valRow,1,refProductionDetails),
Cell(ValRow,11,refProductionDetails :=Cell(valRow,11, refProductionDetails)+1)
)
I have a table named ProductionDetails. 11th column is a counter on the exit of each warehouse. The quantity that we want to leave each warehouse is shown in the first column of the table. We want when the desired quantity is reached by the counter the forklift to move to the next warehouse and do the same.
I attach you a very very simpler model in order to show you what i have in my mind.
Thank you a lot.
With respect,
Vassilis