I am working on creating a Saved Search to help classify internally how much a given client has bought over a period of time (in this case, about the last 3 years). I have the base of the saved search criteria in place, but it isn't providing results that are 100% accurate.
Here is where I'm at so far:
Under Criteria Tab > Standard Subtab
*Type = is Sales Order
*Date = is after the end of 3 years ago (12/31/2014)
Under Criteria Tab > Summary Subtab
*SUM (Summary Type) | Amount (Field) | Is greater than or equal to $XXX.XX
Under Results Tab > Columns Subtab
*Name (Field) | Group (Summary Type)
*Amount (Field) | Sum (Summary Type)
The results I get are OK, but when I look into a few random customer records, I see discrepancy from the resulting total versus the actual total purchased in the same time frame. In this case, the saved search's amount total was a little more than double what the total lists in the customer record. So, it seems as if my saved search criteria is also drawing from whatever amount is invoiced/paid by credit card.
I tested this theory by adding:
Under Criteria Tab > Standard Subtab
*Type = is not Credit Card Sale or Invoice
This does not effect my results.
Any ideas would be greatly appreciated.