Report to show every Work Ticket where a particular raw material is used.

SOLVED

Howdy Sage City community.

Is there a native report in Sage 100 2019 Manufacturing that will allow you to query for a specific item and show a list of Work Tickets in which it was used?

If not, I would like to try and create a custom report.

Thanks much!

Parents
  • +1
    verified answer

    In 2019 Manufacturing there is an Indented Where Used Report that tells you which parent item a component is used for but it doesn't list the work tickets for that parent item.  This would be a custom report likely using the JT_WorkTicketHeader and JT_WorkTicketDetail files. 

Reply
  • +1
    verified answer

    In 2019 Manufacturing there is an Indented Where Used Report that tells you which parent item a component is used for but it doesn't list the work tickets for that parent item.  This would be a custom report likely using the JT_WorkTicketHeader and JT_WorkTicketDetail files. 

Children