Error Deleting Customer in Customers Program
Description of Issue
Error deleting Customer. Check the System Log.
The DELETE statement conflicted with the REFERENCE constraint "FK CustomerDeliveryAddressBill
Context
Customers
General Billing
Accounts Receivable
Utility Billing
Cause
User is unable to delete newly created customer record because bills for the customer were created and then voided, and the CustomerDeliveryAddressId remains on the voided record(s) in the database.
Resolution
General Revenues > Accounts Receivable > Setup > Customers
Click Search
Enter Customer ID
Click Accept
Click Update
Uncheck the box next to Active
Click Accept
Additional Information