RE: [Emerald] CC users switch to renewal

PowerNet ( (no email) )
Fri, 09 Apr 1999 09:49:04 -0400

We do batches every day. This would get old very fast.
Isn't there a version out there that will work?

*********** REPLY SEPARATOR ***********

On 4/8/99, at 8:34 PM, Bernard Andrys wrote:

>You will need to run this after every batch out:
>Update MasterAccounts
> Set PayMethod =3D "Credit Card"
> Where CreditCardAutoBill =3D 1
> AND Datalength(CreditCardNumber) >=3D 13
> AND PayPeriod =3D "Monthly"
>If you don't run the above query your accounts will get really screwed up
>and you will also need to run this query:
>UPDATE iv SET Type =3D 'Credit Card'
>FROM Invoices iv, MasterAccounts ma
>AND iv.CustomerID =3D ma.CustomerID
>AND ma.PayMethod =3D 'Credit Card'
>AND iv.Type =3D 'Renewal'
>You also have to look out for accounts whose credit cards declined during=
>previous batch out. Emerald will keep adding a monthly charge to a=
>whose credit card declined EVERY time you batch out. So you have to read
>through your credit card batch-out file to catch these overbillings.
>Yeah its stupid that you have to do all this, but we've all had to put up
>with Emerald until a fully working version comes out.
>(I've been waiting for 2 months now. For the past month I have considered
>calling IEA for a refund so I can switch to a billing program that works.)
>(10,500 user license)
>> -----Original Message-----
>> From:
>> []On Behalf Of PowerNet
>> Sent: Thursday, April 08, 1999 6:59 PM
>> To:
>> Subject: [Emerald] CC users switch to renewal
>> We are using 2.5.263 and our CC users are randomly being switched
>> back to renewal.
>> What version will fix this problem, not create others, and where
>> can I get it? It seems that they have all been pulled from the web=