How to Update Customers to Have Late Fees

Note that this script should not be used for one off user data entry errors. Customers should correct these manually through the front end.

If you want to change customers to have late fees, you can use the script below and replace the [CustomerNumber] with the proper customer number.  Alternatively, if you don’t want a customer to have late fees, you can alter the script from ‘N’ to ‘Y. If you want to update all customers you can remove the where clause completely. 

update ar_customer

set No_Late_Fees = 'N'

where Customer_Number = '[CustomerNumber]'