How can I filter a saved search with "Main Line is True" to return only vendor bills that contain an item, considering that the "Any Line Item" filter seems to cause issues?

AI generated answer (using internal Slack threads):

To filter a saved search with "Main Line is True" to return only vendor bills that contain an item, you can use the following steps: 1. Create a new transaction search. 2. Set the "Type" criteria to "Vendor Bill". 3. Set the "Main Line" criteria to "True". This will ensure that only the main line of the transaction is returned, not the individual line items. 4. Add a criteria for "Item" and set it to "is not empty". This will ensure that only vendor bills that contain an item are returned. However, if you are trying to filter by a specific item or a custom field on the line level, you may need to set "Main Line" to "False" and use grouping to consolidate the results. For example, if you have a custom field on the line level that associates the line with a specific sales order, you could set "Main Line" to "False", add a criteria for your custom field, and then group the results by the transaction number. Please note that when "Main Line" is set to "False", each line of the transaction will be returned as a separate result. Therefore, if a vendor bill has multiple line items, it will appear multiple times in the search results, once for each line item. Grouping by the transaction number can help consolidate these results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******