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.
Add Comment
1 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

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