RE: 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.

It worked on my case. Thank you @Bessy126

on November 11, 2022.
Add Comment
2 Answers

@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.