Would this be the correct SQL statement to change the send bill check box?
UPDATE SubAccounts
SET SendBill=1
I'm assuming that I would need to check to make sure I only have one sub
account's send bill checked for every master account.
>> 2) Does the "Auto Bill" checkbox in the billing tab under credit card need
>> to be checked to batch process credit cards? (I'm assuming yes)
>
>If the auto-bill is not checked, the account will only be billed
>CC the FIRST time. All other times after that will be billed via
>renewal.
Wait a minute, I thought it was the opposite way. For testing purposes, I
have auto bill enabled on two MBRs. When I select Credit Card and put in
the appropriate date to create invoices, I only come up with 2 services to
bill. I'm assuming it is the two services where I have the auto bill
checked that are getting invoiced.
So how about another SQL statement to update the Auto Bill checkbox. How
would this one work?
UPDATE MasterAccounts
SET CreditCardAutoBill=1
WHERE CreditCardNumber IS NOT NULL
I've tried changing some of the table's default values, but Emerald seems
to have its own defaults. Any way to change that? TIA
David Edwards
System Administrator - Oakweb.com
Lake Tahoe's Premier Internet Service Provider
1-800-61-TAHOE