is it possible to merged or join the 2 transaction for example sales order and assembly build, i want to make an Sales Order with Assembly Build document number on the save saearch

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you want to join or merge two transactions, specifically a Sales Order and an Assembly Build, and you want the Assembly Build document number to appear in the Sales Order saved search. While it's not directly possible to join these two transactions in a saved search, you can achieve this by using a formula field in your saved search. Here's how you can do it: 1. Create a saved search for Sales Orders. 2. In the Results tab, add a new column with a Formula (Text) field. 3. In the formula field, use the CONCAT function to combine the Sales Order number with the Assembly Build document number. The formula would look something like this:

CONCAT({salesorder.number}, ' ', {assemblybuild.documentnumber})

This will create a new column in your saved search that combines the Sales Order number with the Assembly Build document number. Please note that this solution assumes that there is a direct relationship between the Sales Order and the Assembly Build, and that the Assembly Build document number is available in the context of the Sales Order. If this is not the case, you may need to create a custom field or use a script to populate the Assembly Build document number on the Sales Order. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******