Hi everyone, is it possible to create a Transaction Saved Search that looks for duplicate line items within a transaction? Any suggestion on how to go about this?

Hi Juan, I do this using SuiteQl with the query below. I use the query tool from Tim to query https://timdietrich.me/netsuite-suitescripts/suiteql-query-tool/

select BUILTIN.DF(tl.item) as item,

tl.linesequencenumber,

tl.quantity,

tl.rate,

tl.custcol_receipt_identifier

from Transaction t

join TransactionLine tl

ON ( tl.Transaction = t.ID )

where type ='PurchOrd'

and t.ID = 1490919

and tl.item in (select item

from Transaction t

join TransactionLine tl

ON ( tl.Transaction = t.ID )

where type ='PurchOrd'

and t.ID = 1490919

group by item

HAVING COUNT(*) > 1)

order by BUILTIN.DF(tl.item),tl.linesequencenumber

@GeneralKenobi Thanks! I also had this in mind. Looking for a more user friendly approach but I think I can make this work. Thanks again!

I wonder if a summarized saved search would work with summary criteria for COUNT of item > 1, and in the results using MAX of item.