I am trying to create a saved search that identifi...
# general
b
I am trying to create a saved search that identifies any duplicate items on a sales order. I would think a grouping on Transaction, Item and then a Count on item would bring back '2' for any items more than once would be the result, but I cannot make this work for some reason. I just want a report that shows when an item is entered twice on the same transaction. Any suggestions?
r
Group by transaction internal id or document number, Item. Count line unique key or line id.
m
I can confirm raghav’s answer is correct
I added in summary criteria: Count Line ID is greater than 1
b
Fantastic! Thanks that worked.