Consumption Logic - to consume planned quantity from packing sheet

[JArjoon]

Hello all, 

I am stuck on below issue. I have two files: 

- An order file: which shows per order & material, when are the expected delivery dates. The quantities here are the requested quantities. 

- A planning packing file: which shows per material & batch - when the batches will be released. The quantities here are the quantity in production. 

Order File

Planned packing file: 

My ask is to bring the Purchase Order number on the planned packing file. 

Expected results: 

I) I have three orders for material 1 (33k, 16k & 16k) - so for batch RER: POA; batch REZ: POA itself [as quantity from POA has not yet been consumed]; Batch REB: POB 

ii) Batch ZAC: POD

I have tried several options and am getting stuck.. Attached is the dummy data (in excel).

Any assistance is super appreciated. 

K

[Kottapally_Ramesh]

Hi @JArjoon 

I have used join & unique tool to get the Purchase Order number on the planned packing file.

Please check & let me know if the results are expected or not?

[JArjoon]

Hello Ramesh, 

Thank you for replying. 

However, it did not provide the correct result. 

PO A is 33,000 - it would be consumed by batch REB & RER. 

Batch REZ will need to go under PO B. 

[Kottapally_Ramesh]

Can you share your expected output, it will be easy to understand & implement the logic. 

[JArjoon]

Hello Ramesh, 

Pls see above. 

J