Hello,
I have created a custom field on our Purchase Orders, the field is a list of work orders and allows the users to link the WO to the PO - sometimes we can have multiple WO's linked to the one PO. Field Id = custbody35.
We have a report which runs from the Open Purchase Orders, we have been able to find the custom 'Relates to WO' field.
I have now been asked to add to the report and pull in the Assembly from the WO.
The Assembly or Item fields do not show under the 'Related to WO' join in the report.
I tried to create a Saved Search, pulling from Transactions = PO and WO. In the search, I am able to see the Assembly and Item fields however only the items (components) are listed, I can't get the Assembly to be shown. I have set the search to Main line = T and = Either, no luck on either attempt. I have tried using a formula {custbody35.assemblyitem} and the field displays as empty.
Hoping to be able to bring in the Assembly from the WO onto the report. Appreciate help!!