Consumption Logic - to consume planned quantity from packing sheet

Question

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

Dummy Data.xlsx

JArjoon · Answer

Hello Ramesh,

Pls see above.

J

Kottapally_Ramesh · Answer

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

JArjoon · Answer

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.