AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Production Order Re...
 
Notifications
Clear all

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).
Sincerely,
Tim Rodman

Questions Production Order Report with Phantom Items

Acumatica Report Designer
Last Post by sarah.bond 6 months ago
1 Posts
1 Users
1 Likes
100 Views
RSS
sarah.bond
Posts: 1
 sarah.bond
Topic starter
August 22, 2022 10:01 am
(@sarah-bond)
Member
Joined: 2 years ago

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.

image

 

image

 

image

 

image

 

image

 

image

 

image
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,239 Topics
  • 9,872 Posts
  • 4 Online
  • 1,813 Members
Our newest member: Marion Hooley
Latest Post: Export Scenario - Export same row twice (Conditionnal)
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×