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
1 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:

SUMMARY TYPE
FIELD
DESCRIPTION
FORMULA
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

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   Limebox   Become a Sponsor