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, 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!
-Suite Advisory-
ChasePounders did this help?
Bessy126
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.
lcarana404
It worked on my case. Thank you @Bessy126