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?
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