/
Error Deleting Customer in Customers Program

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










Related content

Unable to delete General Billing Customer record
Unable to delete General Billing Customer record
More like this
Error on execute delete when deleting Bank Code Account
Error on execute delete when deleting Bank Code Account
More like this
Error while deleting deduction code in Deduction and Benefit Master
Error while deleting deduction code in Deduction and Benefit Master
More like this
Error modifying 1099 box code on invoice - apvn1099io_delete: Execute delete_apvn1099...
Error modifying 1099 box code on invoice - apvn1099io_delete: Execute delete_apvn1099...
More like this
Error deleting Vendor Remit Address - Error when executing deleteChangeSetGroups -691
Error deleting Vendor Remit Address - Error when executing deleteChangeSetGroups -691
More like this
Vendor Merge Fails on constraint VendorsOnContracts, 'VendorId'
Vendor Merge Fails on constraint VendorsOnContracts, 'VendorId'
More like this