This constituent has associated revenue and therefore cannot be deleted

When deleting a constituent the user receives the error "This constituent has associated revenue and therefore cannot be deleted." despite all revenue being removed.

This may be caused by existing rows in FINANCIALTRANSACTIONLINEITEMADJUSTMENT.
The associated revenue must first be removed. As the system is not handling this automatically the task may need to be handled by a technical resource via a SQL script.

Steps to Duplicate

Delete a constituent.

Was this article helpful?