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

Was this article helpful?
Thank you for your feedback!
User Icon

Thank you! Your comment has been submitted for approval.