All Process Orders containing specific materials

[former_member1295206]

I need to pull a report that shows all process orders (released or planned) that contain very specific materials.

I also need to be able to identify those raw materials within each process order.

e.g Process Order ABC for Product 1234 contains material XYZ, EFG & JKL

I had thought I could run this in COID using the list of raw materials under the "component" section but while it lists all the Product codes and process orders, i can't see where each raw material sits within the finished good product code.

I also looked at running this (needs to have batch data) and then changing layout to add in the info but that doesn't work either.

Don't want to have to write a sqvi report as its not my area of expertise.

TIA