netsuite saved search for transactions which has m...
# ask-stanley-ai
k
netsuite saved search for transactions which has more than 20 line items
c
AI generated answer (using internal Slack threads):
To create a NetSuite saved search for transactions which have more than 20 line items, you would need to follow these steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Transaction as the record type for the search. 3. In the Criteria tab, add two criteria: - Main Line is False (this will allow the search to look at line items instead of the transaction as a whole) - Formula (Numeric) is greater than 20. For the formula, you can use
COUNT({line})
. This will count the number of line items for each transaction. 4. In the Results tab, add the fields you want to display for each transaction. At a minimum, you would probably want to include the transaction number, date, and customer. 5. Save and run the search. This will give you a list of transactions where the number of line items is greater than 20. Please note that this search could potentially return a large number of results, depending on the volume of transactions in your NetSuite account. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.849609375
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.848571897
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.848205566
Please provide your feedback on this answer.