To Display one or more Invoice Number in saved search in single line with no item fulfillment lines

In the Results tab, configure the fields you want to display in the search results. To include the invoice number using a formula, follow these steps:

1. Add a New Column:

• Click on New Column and select Formula (Text) as the field type.

1. Set Summary Type:

• Set the Summary Type to Maximum. This helps in aggregating the results and ensuring unique invoice numbers are displayed.

1. Enter the Formula:

• In the Formula field, enter the following formula to concatenate distinct billing transaction numbers:

ns_concat(distinct({billingtransaction.number}))

1. Other Columns:

• Add any other columns you find necessary, such as Date, Customer Name, Amount, etc.

5. Save and Run the Search

• Once you’ve configured the criteria and results, save the search by giving it a meaningful name, such as “Invoices Without Item Fulfillment”.
• Run the search to display the list of invoices that do not have corresponding item fulfillment lines.