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.
Here are the criteria for this transaction search:
type -- is Sales Order
main line -- is false
tax line - is false
shipping line -- is false
Status -- is any of Sales Order:Billed, Sales Order:Closed, Sales Order:Partially Fulfilled, Sales Order:Pending Billing, Sales Order:Pending Billing/Partially Fulfilled
Applying Transaction : type -- is item fulfillment
Quantity -- is greater than 0
Applying transaction : location -- is xxxxxx
Applying transaction : is within Today
Item: Current standard cost -- is greater than 0
I will be grateful for whatever assistance you can provide. I have stared at this until my head hurts.