/
Error deleting fund - The DELETE statement conflicted with the REFERENCE constraint

Error deleting fund - The DELETE statement conflicted with the REFERENCE constraint

Description of Issue

User is attempting to delete a fund and receives the error

Program stopped at 'glcoaseg.4gl', line number 3070.

SQL statement error number -6372 (-50000).

[Microsoft][SQL Server Native Client 11.0][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "FK_BudgetProjectionFunds_Segments". The conflict occurred in database "mun5201prod", table "dbo.BudgetProjectionFunds", column 'SegmentId

Context
  • Chart of Accounts Segments

  • Chart Manager

Cause

Fund is included in an existing budget projection

Resolution

The fund may be removed from the budget projection so long as the projection has not been posted.

Financials > Budget Processing > Define/Start Budget Projection

  1. Search for the projection

  2. Update

  3. Click the folder icon in the Projection fund(s) textbar

  4. Update

  5. Uncheck the fund being deleted

  6. Accept

  7. Back

  8. Accept

  9. Attempt to delete the fund once more

For any further issues with deleting the fund, identifying which projections the fund was included in, or if the projection is in a Posted status, please contact Enterprise ERP General Ledger Support for assistance.

Additional Information

 

Related content

Getting error when delete a payroll Allocation Code
Getting error when delete a payroll Allocation Code
More like this
Error The DELETE statement conflicted with the REFERENCE constraint FK_Organizations.CustomData.Global_Organizations
Error The DELETE statement conflicted with the REFERENCE constraint FK_Organizations.CustomData.Global_Organizations
More like this
'Error deleting BudgetDetailRequests...' Error When Deleting Budget Projection
'Error deleting BudgetDetailRequests...' Error When Deleting Budget Projection
More like this
Could not Delete error is received when trying to delete a funding source grantor code
Could not Delete error is received when trying to delete a funding source grantor code
More like this
Central Budget Entry - object Object error deleting budget detail record with NULL unit cost
Central Budget Entry - object Object error deleting budget detail record with NULL unit cost
More like this
Error deleting from glmaster when merging accounts where account is defined within a budget scenario package
Error deleting from glmaster when merging accounts where account is defined within a budget scenario package
More like this