Hey guys,
How can I find Purchase Order IDs that s...
# suitescripta
Artur_K
04/28/2022, 1:39 PMHey 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 PMyou are looking for groupings of records, which means summary criteria / columns
battk
04/28/2022, 6:54 PMgroup by custbody_1 and add a summary criteria on the count
battk
04/28/2022, 6:54 PManything with more than 1 count has duplicates