How to Create Saved Search to figure Duplicate items in Order ?

Hello suite family

I need to create a search to get all sales order with duplicate items


Rookie Asked on November 7, 2021 in Saved Searches.
Add Comment
2 Answer(s)

Hello every one , actually the right solution  that’s work with me is:

In criteria section:

Type: Sales order

Date: 1/10/2021 ( This to limit the number of orders)

In summary section:

Count Line Unique Key is greater than 1

In results tab , to organize your  results:

but a count  Line Unique Key , and make group for any columns you want like location , status … etc

Rookie Answered on November 10, 2021.
Add Comment


Use this formula – Summary criteria to do COUNT({line}) – COUNT({item}) > 0

Beginner Answered on February 7, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor