Duplicate Lines on Saved Search

TL;DR: Need help displaying the PO Document number on an SO search without duplicates.

I am having a particular issue with a saved search for sales orders but I would like to show the PO number as a column. I had to set main line to false after adding the Purchase Order Fields: Document Number to the search to actually get document number to appear. My results looked fine but I soon realized I had a lot of duplicates.  I set the Main line, Tax line, COGS line, and Shipping line to False and I am still getting duplicates. Does anyone know how to display the PO Document number on the SO search without duplicates?

ChasePounders did this help?

on July 20, 2021.

Sounds like you are pulling those additional lines in from the purchase order. Set the main line to true under the purchase order fields and you should be able to get rid of those dups.

on July 29, 2021.
Add Comment
2 Answer(s)

If you are still getting duplicates then I would recommend modifying the results section of the saved search to “Group” by SO internal ID. The other result columns would also need to be grouped accordingly with GROUP, MAX, MIN, etc in order to display in the saved search results, but this should achieve the desired result. I hope this helps!

Beginner Answered on July 15, 2021.
Add Comment

@ChasePounders, could you mark my answer as the best answer if this resolved your issue? This will allow other users to follow the same advice should they encounter the same issue. Thanks!

Beginner Answered on August 3, 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