[Emerald] emerald overbilling customers who's credit cards declined

Bernard Andrys ( (no email) )
Tue, 30 Mar 1999 14:47:12 -0500

Emerald: 2.5.261

Is anyone else having problems with Emerald over billing customer's whose
credit cards declined?

Any customers whose credit cards didn't go through get a monthly charge
added EVERY time a batch out is run.

The history table is gets really screwed up for those customers

Date Amount
3/27 74.75
3/26 59.80
3/25 44.85
3/24 29.90
3/23 14.95

I have to manually go through the emer_out.txt file and remove the charges.
Then I have to go to Emerald, look up the customer by credit card and void
all the invalid charges.

Has anyone else seen this? If so, does IEA have an SQL query that can be
run to fix this (something to run before or after every batch out)
temporarily until a working Emerald is available?

I've posted this problem before but didn't seen any response from IEA or any
users.

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html