Master Cycle Billing - Invalid Use of Null

If you receive the Invalid use of null error while trying to run cycle billing on your master account, it is most likely a null in the reference column in AR_customer_recurring. You can fix this with the script below

update AR_CUSTOMER_RECURRING

set REFERENCE = ''

where REFERENCE IS NULL