Find link between which order supplies which demand!!

[mergim]

Hello All,

I am trying to find a link between which purchase order will supply which work order demand. For example, the first work order, 43081340 will be supplied by the first purchase order 59747( )(1)(1) as 100.000 can cover 25.459.
The same goes for the next work order, 43081341, again, here the first purchase order 59747( )(1)(1) will also be able to supply this amount as 25.459 + 23.189 are still not higher than 100.000. When the third work order comes, 43081094, here we have multiple purchase orders that would have to supply in order to cover the demand. Here we would need PO 59747 1-2, 1-3, and 1-4. Right now, I am doing this manually, so I hope you guys can help me with some sort of function or ideas. Please, feel free to ask for more info if needed.

*work order demand = is the material consumption

SORT DATE	ITEM NUMBER	ITEM DESCRIPTION	TYPE	ORDER NUMBER	QTY	Date	Acumulated	Link
100001	123456	Apples	Purchase order​	59747( )(1)(1)​	100.000​	27-06-2023​	100.000​	1
100002	123456	Apples	Purchase order​	59747( )(1)(2)​	100.000​	27-06-2023​	200.000​	2
100003	123456	Apples	Purchase order​	59747( )(1)(3)​	100.000​	11-07-2023​	300.000​	2
100004	123456	Apples	Purchase order​	59747( )(1)(4)​	100.000​	11-07-2023​	400.000​	2
100005	123456	Apples	Purchase order​	59747( )(1)(5)​	100.000​	25-07-2023​	500.000​	3
100006	123456	Apples	Purchase order​	59747( )(1)(6)​	100.000​	25-07-2023​	600.000​	3
100007	123456	Apples	Work order demand​	43081340​	- 25.459​	29-07-2023​	574.541​	1
100008	123456	Apples	Work order demand​	43081341​	- 23.189​	12-08-2023​	551.352​	1
100009	123456	Apples	Work order demand​	43081094​	- 258.238​	22-08-2023​	293.114​	2
100010	123456	Apples	Work order demand​	43081342​	- 23.138​	26-08-2023​	269.976​	2
100011	123456	Apples	Purchase order​	59747( )(1)(7)​	100.000​	05-09-2023​	369.976​	4
100012	123456	Apples	Purchase order​	59747( )(1)(8)​	100.000​	05-09-2023​	469.976​	5
100013	123456	Apples	Work order demand​	43081343​	- 28.908​	09-09-2023​	441.068​	2
100014	123456	Apples	Work order demand​	43081098​	- 234.584​	18-09-2023​	206.484​	3
100015	123456	Apples	Purchase order​	59747( )(1)(10)​	100.000​	19-09-2023​	306.484​	5
100016	123456	Apples	Purchase order​	59747( )(1)(9)​	100.000​	19-09-2023​	406.484​	6
100017	123456	Apples	Work order demand​	43081344​	- 29.070​	23-09-2023​	377.414​	4
100018	123456	Apples	Purchase order​	59747( )(1)(11)​	100.000​	03-10-2023​	477.414​	6
100019	123456	Apples	Purchase order​	59747( )(1)(12)​	100.000​	03-10-2023​	577.414​	6
100020	123456	Apples	Work order demand​	43081345​	- 29.851​	06-10-2023​	547.564​	4
100021	123456	Apples	Work order demand​	43081105​	- 234.024​	10-10-2023​	313.539​	6
100022	123456	Apples	Work order demand​	43081121​	- 294.219​	03-11-2023​	19.320​	6
100023	123456	Apples	Purchase order​	59747( )(1)(14)​	100.000​	07-11-2023​	119.320​	7
100024	123456	Apples	Purchase order​	59747( )(1)(13)​	100.000​	07-11-2023​	219.320​	7
100025	123456	Apples	Purchase order​	59747( )(1)(15)​	100.000​	14-11-2023​	319.320​	7
100026	123456	Apples	Work order demand​	43081127​	- 296.003​	28-11-2023​	23.317​	7
100027	123456	Apples	Purchase order​	59747( )(1)(16)​	100.000​	05-12-2023​	123.317​	8
100028	123456	Apples	Purchase order​	59747( )(1)(17)​	100.000​	19-12-2023​	223.317​	8
100029	123456	Apples	Purchase order​	59747( )(1)(18)​	100.000​	19-12-2023​	323.317​	8
100030	123456	Apples	Work order demand​	43081135​	- 304.108​	26-12-2023​	19.209​	8

 

[Joe4]

This appears to be a duplicate/continuation of this thread: Function to show which value belongs to which

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.