In version 6.X the customer have expanded options on whether each individual type of invoice can be printed or emailed. If they need to change a large mass of customers, you can use the script below by adjusting the Y or N on the script and including the necessary where clause.
update b
set b.Email_Cycle_Invoice = 'N',
b.Email_Job_Invoice = 'N',
b.Email_Other_Invoice = 'N',
b.Email_Service_Invoice = 'N',
b.Print_Cycle_Invoice = 'Y',
b.Print_Job_Invoice = 'Y',
b.Print_Other_Invoice = 'Y',
b.Print_Service_Invoice = 'Y'
--select *
from ar_customer_bill b
