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?
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!