Formula syntax to show transaction shipdate field from header of SO on a line item saved search

AI generated answer (using internal Slack threads):

To show the transaction shipdate field from the header of a Sales Order (SO) on a line item saved search, you can use a formula field. However, the shipdate field is not directly available on the line item level. You would need to use a join to get this information. Here's how you can do it: 1. In your saved search, go to the Results tab. 2. Click on 'New Field' to create a new formula field. 3. In the formula field, use a SQL expression to join the transaction record with the line item record. The formula would look something like this:

{transaction.shipdate}

Please note that the exact syntax might vary depending on your specific NetSuite setup and the exact field names you have. The

{transaction.shipdate}

is a placeholder and you might need to replace 'transaction' and 'shipdate' with the actual field names in your NetSuite account. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******