In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Production Order Report with Phantom Items
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.