https://netsuiteprofessionals.com logo
a

Artur_K

04/28/2022, 1:39 PM
Hey guys, How can I find Purchase Order IDs that share a custom field with Sales Orders? E.g. Purchase Order custbody_1 has the same value as Invoice custbody_1 Can I script a search that looks for Purchase Orders that have the same value for custbody_1 as the Invoice custbody_1?
b

battk

04/28/2022, 6:53 PM
you are looking for groupings of records, which means summary criteria / columns
group by custbody_1 and add a summary criteria on the count
anything with more than 1 count has duplicates