I know this should be simple but I am trying to create a search that will show then a sales order is created and the contents of a custom field was entered on a previous order.
I created a custom transaction body field custbody_cust_authnum which represents a release authorization number for a customers blanket PO. This authorization number should only be used once. I am trying to create a duplicate detection alert email but first I am just trying to get a saved search to show the duplicates.
I created a search, Criteria Type=Sales Order, MainLine=Yes
On the Summary Criteria tab – Summary Type = Count, Field Customer Auth Number (Custom) is greater than 1
If I just list the result, I get back every sales order entered
If I group by my custom field and Count of internal ID, I receive no records.
I know there are duplicates PLUS I even created 2 test transactions with the duplicate value in the custom field
Any insight would be appreciated.
John
This is a cached copy. Click here to see the original post.