Cannot Delete Unused General Ledger Account Number

Error:The DELETE statement conflicted with the REFERENCE constraint FK_APDetal_ChtActs

Cause:Zero values inserted into dbo.GL

Solution:

Run the following SQL statement:

delete gl where Beg_Bal = 0 and Debit = 0 and credit = 0 and end_bal = 0

Details:

Zero values may be inserted into dbo.GL. Although no activity has happened, the zero values prevent the deletion of the account number.

Symptoms:Cannot delete inactive general ledger account