how to create a saved search that returns all purchase order information and in the results i want to display an extra field that displays the account of the vendor payment account if the purchase order is billed

AI generated answer (using internal Slack threads):

To create a saved search that returns all purchase order information and displays an extra field that shows the account of the vendor payment account if the purchase order is billed, you can follow these steps: 1. Navigate to

Reports > Saved Searches > All Saved Searches > New

. 2. Select

Transaction

from the list. 3. In the

Criteria

subtab, set the

Type

to

Purchase Order

. 4. In the

Results

subtab, add the fields you want to display. For example, you might want to include

Name

,

Document Number

,

Amount

,

Status

, etc. 5. To display the account of the vendor payment account if the purchase order is billed, you need to add a

Formula (Text)

field in the

Results

subtab. The formula would be something like this:

CASE WHEN {status} = 'Billed' THEN {account} ELSE NULL END

. This formula checks if the status of the purchase order is 'Billed', and if so, it displays the account. If not, it displays nothing (NULL). 6. Save the search. Please note that the exact field names and their availability may vary depending on your NetSuite setup. Also, the formula provided is a simplified example and may need to be adjusted to fit your exact requirements. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******