Questions Production Order Report with Phantom Items

Hello -

We want to start using Phantom routing on our BOMs. However I need the Phantom Inventory ID to show up on the Production Ticket Details.

The raw materials for the phantom items are pulled into the Production Ticket but I also want to show the Inventory ID for the phantom items.

I was able to get the Phantom BOM ID to pull into the report but how do I link the Phantom BOM ID to pull in the Inventory ID/Item Description?

What joins do I need to make this happen? Or what would be the best way to group/sort this report?

Attached is screen shot of what my production ticket looks like and the tables from the report, any help would be appreciated.