[Emerald] Warning: 2.5.278 with credit card autobill

Bernard Andrys ( (no email) )
Mon, 14 Feb 2000 21:32:20 -0500

I found a bug in the Emerald client 2.5.278 that's been corrupting accounts
for the past 4 months. Customer accounts are being changed from
"credit-card" to "renewal". There are just a few that are changed each time
a batch-in is done but it adds up over time if you don't catch it. I
haven't found out why this is occurring so the changed accounts seem random.

If anyone has seen this problem (or sees it after running the SQL listed
below), please let me know. Clean up is a pain because if you don't catch
it immediately, you end up with renewal invoices that need to be voided.
Here is the SQL I use to list accounts that have been corrupted by Emerald
2.5.278.

SELECT dbo_MasterAccounts.LastModifyDate, dbo_MasterAccounts.LastModifyUser,
dbo_SubAccounts.Login, dbo_MasterAccounts.CreditCardNumber
FROM dbo_MasterAccounts INNER JOIN dbo_SubAccounts ON
dbo_MasterAccounts.CustomerID = dbo_SubAccounts.CustomerID
WHERE (((dbo_MasterAccounts.Active)=1) AND
((dbo_MasterAccounts.CreditCardNumber) Is Not Null) AND
((dbo_MasterAccounts.CreditCardAutoBill)=1) AND
((dbo_MasterAccounts.PayMethod)='invoice') AND
((dbo_MasterAccounts.PayPeriod)="monthly-cc"))
ORDER BY dbo_SubAccounts.Login;

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart