Re: [Emerald] annual accounts -- autobill = 0 (2.5.236)

Dale E. Reed Jr. ( (no email) )
Fri, 05 Feb 1999 13:07:41 -0800

Alexander Blauvelt wrote:
>
> I forgot to mention its emerald 2.5.236
>
> > They changed the way autobill works with version 2.5....
> >
> > 2.5.xxx will bill the card again in 12 months no matter what autobill is
> >
> > 2.2.xxx will only bill the card the first time if autobill = 0
>
> So the Credit Card - AutoBill field is useless ?

No. The next update will automatically change the account paymethod
from CC to Renewal after it creates the first CC invoice if the the
CC Auto Bill is set to 0.

I've used a query like this to change them manually, though:

Update MasterAccounts
Set Paymethod = "Invoice"
Where Paymethod = "Credit Card" and CreditCardAutoBill = 1
and Exists (Select InvoivceID From Invoices
Where MasterAccounts.CustomerID = Invoices.CustomerID
and Type = "Credit Card")

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com

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