I am trying to pull the work order number into a sales order pending fulfillment report. We are creating work orders from sales orders. How do I pull the work order number in my report?

AI generated answer (using internal Slack threads):

To pull the work order number into a sales order pending fulfillment report, you can create a saved search on the Sales Order record type. In the results tab of the saved search, you can add a column for the field 'Generated Work Order'. This field will display the internal ID of the work order generated from the sales order. If you need the work order number instead of the internal ID, you can use a formula text field in the results tab of the saved search. The formula would be

{generatedworkorder.number}

. This will display the work order number in your report. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******