Some customers are getting multiple E-mail statements sent out to them from previous terms. What would cause this?
Feb 10 2004
Emerald 4.5.7 and earlier automatically sends Email statements that have not been previously marked as sent. In some instances for example the account previously had a Send Method of other or an incorrect email address preventing the statement from being marked has having been sent.. When the condition is resolved all previously unsent Statements are sent to the customer.
Starting with Emerald 4.5.8 Emerald will only automatically email the latest statement to the customer.
The following query shows the number of unsent statements per customer. Any customers having more than one statement should be investigated for possible misconfiguration that would have prevented previous notices from being sent.
SELECT COUNT(*),CustomerID FROM Statements WHERE SentDate IS NULL GROUP BY CustomerID ORDER BY 1 DESC
