In my NetSuite journey, I have frequently encountered duplicate lines in searches and usually they are fixed with a mainline filter. However, I am baffled this time.

I have a transaction search of Sales Orders that have IFs against them. While this search works great for one location, another location has intermittent duplicate lines causing havoc. I do not know why some lines duplicate and others do not. However, I have figured out how to turn this unacceptable behavior on and off. I see the duplication whenever I reference item.currentstandardcost in the results. Of course, the manager wants a gross margin on the report, which requires the cost field.