I would like to know how to create a report which shows the related material of a subcontract operation on a packing list.
The standard SSRS report shows the part that the subcontract operation is ending up as, but we need the related material to show on the picking list report. I know how to edit reports but not sure how to get to the related material table.
You would join to the JobMtl table with the following fields:
JobOper.Company = JobMtl.Compnay
JobOper.JobNum = JobMtl.JobNum
JobOper.AssemblySeq = JobMtl.AssemblySeq
JobOper.OprSeq = JobMtl.RelatedOperation