RE: [Emerald] Invoice next erm

Ronnie D. Franklin ( )
Mon, 19 Apr 1999 18:19:36 -0500

I have not pinpointed the exact "rules" that Emerald follows... but am
working on it with IEA....

As for the script.. First, I did a Report that provided me with all
customers who were set for "Credit Card"... The report gave me misc info,
and what AutoBill was set to... I then manually corrected any Autobill that
was set to what I believed incorrect... Then, with my database being as
close to correct as possible, I ran credit cards.. then the following

Update MasterAccounts
Set Paymethod = "Credit Card"
Where Paymethod = "Invoice"
and CreditCardAutoBill = 1

The above script assumes 2 things...

1. Your accounts have autobill = 1 for those that want to be billed every
billing cycle and

2. autobill = 0 for those who only want to be billed THIS Time...