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

  1. Click Search

  2. Enter Customer ID

  3. Click Accept

  4. Click Update

  5. Uncheck the box next to Active

  6. Click Accept

Additional Information