Loop

[Rafa]

Hello,

I have a problem. I wanna order lines with following logical: I want to consum stock as first (always ID 1) and only when line goes to negative I want to use PO line.

I'm able to do it just manually. My goal is to make this loop automatic. I could have more then 10 PO lines.

Attached the flow I prepared. Is it the right way or not?

Pls help me!

TO BE

ID	TYPE	QT	QT AVAILABLE
1	STOCK	8	8
2	REQ	-2	6
3	REQ	-2	4
4	REQ	-2	2
7	REQ	-2	0
5	PO	4	4
8	REQ	-4	0
6	PO	4	4
9	REQ	-2	2
10	REQ	-2	0

[abacon · Accepted solution]

@Rafa I would look into iterative macros, here is a video on how to set one up. Basically you have it go through each line of your workflow, and do the conditions you are wanting.

In the meantime, you want it to start on Stock, then go through each Req until the QT available is negative, once that happens, jump to the next PO, and repeat, correct?

https://www.youtube.com/watch?v=AByfTPqrUrQ

Bacon