I have a transactions saved search that is for Vendor Bills. I want to add another few columns with the vendor bill payment number, payment date, and payment amount. How do I add these since its a related transaction?

AI generated answer (using internal Slack threads):

To add the vendor bill payment number, payment date, and payment amount to your saved search for Vendor Bills, you can use the "Applying Transaction Fields" feature in NetSuite. This allows you to join fields from related transactions. Here are the steps to do this: 1. Go to your saved search and click on the "Results" subtab. 2. Click on the "New Field" button. 3. In the "Summary Type" dropdown, select "Group". 4. In the "Field" dropdown, select "Formula (Text)". 5. In the "Formula" field, enter the formula that corresponds to the field you want to add. For example, for the payment number, you could use

{applyingtransaction.number}

. For the payment date, use

{applyingtransaction.date}

. For the payment amount, use

{applyingtransaction.amount}

. 6. In the "Label" field, enter the name you want to give to this new column. 7. Click "Save". Please note that the formula might need to be adjusted based on your specific needs and the exact structure of your data. Also, keep in mind that this will group the results by the new field you added. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******