This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

If I wanted to create a search to find sales order that have the same line item listed twice on the sales order (finding duplication mistakes) what would be the best way to go about this? 

Create a saved search and use item name count

CRITERIAS
STANDARD:
transaction type = so
main line = false
ship line = false
tax line = false
SUMMARY
count line id greater than 1

RESULT SET
group by document number
group by item
count line id

SHould this be a saved transaction search or saved Item search

Im getting no results for some reason. hmmm

Here is a sales order with duplicate lines as an example

Could you send a picture of your criteras (both standard and summary) and your result set?

Sorry. You shall group by item and count line id in your result set