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