Hey guys How can I find Purchase Order IDs that share a cust

Question

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

battk · Answer

you are looking for groupings of records which means summary criteria columns

battk · Answer

group by custbody 1 and add a summary criteria on the count

battk · Answer

anything with more than 1 count has duplicates