Production Order Report with Phantom Items - Acumatica Report Designer https://www.augforums.com/forums/acumatica-report-designer/production-order-report-with-phantom-items/ Acumatica User Group Forums en-US Fri, 17 Jul 2026 17:35:46 +0000 wpForo 60 Production Order Report with Phantom Items https://www.augforums.com/forums/acumatica-report-designer/production-order-report-with-phantom-items/#post-10150 Mon, 22 Aug 2022 14:01:38 +0000 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.

2927

 

2928

 

2929

 

2930

 

2931

 

2932

 

2933]]> Acumatica Report Designer sarah.bond https://www.augforums.com/forums/acumatica-report-designer/production-order-report-with-phantom-items/#post-10150