/
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
Click Search
Enter Customer ID
Click Accept
Click Update
Uncheck the box next to Active
Click Accept
Additional Information
, multiple selections available,
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