*********** 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
>WHERE Date BETWEEN 'X' AND 'Y'
>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=
a
>previous batch out. Emerald will keep adding a monthly charge to a=
customer
>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.)
>
>
>Bernard
>(10,500 user license)
>
>
>> -----Original Message-----
>> From: emerald-request@iea-software.com
>> [mailto:emerald-request@iea-software.com]On Behalf Of PowerNet
>> Sent: Thursday, April 08, 1999 6:59 PM
>> To: emerald@iea-software.com
>> 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=
site.
>>