formula to show header ship date in a sales order saved search when the main kine is false

AI generated answer (using internal Slack threads):

To show the header ship date in a sales order saved search when the main line is false, you can use a formula text field in your saved search. Here is the formula you can use:

CASE WHEN {mainline} = 'T' THEN {shipdate} END

This formula checks if the main line is true, then it will return the ship date. If the main line is false, it will return null. Please note that the ship date will be displayed on the line where the main line is true. If you want to display the ship date on all lines, you can use a formula like this:

MAX({shipdate}) OVER (PARTITION BY {transaction.number})

This formula will display the maximum (latest) ship date for each transaction number, effectively showing the ship date on all lines of the transaction. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******