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

Ronnie D. Franklin ( ronnie@itexas.net )
Fri, 5 Feb 1999 15:32:13 -0600

FYI...

Change one item...

> Where Paymethod = "Credit Card" and CreditCardAutoBill = 0

> 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")

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