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
script...
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...