Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_GL7TRANSACTIONS_GL7FISCALPERIODSID_GL7FISCALPERIODS".

 When clicking Save in a new invoice for vendor, Air Rite, Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_GL7TRANSACTIONS_GL7FISCALPERIODSID_GL7FISCALPERIODS". The conflict occurred in database "FE_573", table"dbo.GL7FISCALPERIODS", column 'GL7FISCALPERIODSID'.Native error:547[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.Native error:3621 occurs.
We are currently evaluating this issue and will update this article when we have more information.

If the problem occurred when editing a recurring Invoice that had already been generated, try the steps below.
1. Close the Invoice without saving.
2. Reopen the Invoice and make your changes
3. Save and Close

Steps to Duplicate

1. Log into Financial Edge NXT
2. Create a new invoice for vendor, Air Rite
3. Enter all amounts, distribution, project, etc. 
4. Click Save and 
Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_GL7TRANSACTIONS_GL7FISCALPERIODSID_GL7FISCALPERIODS". The conflict occurred in database "FE_573", table"dbo.GL7FISCALPERIODS", column 'GL7FISCALPERIODSID'.Native error:547[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.Native error:3621 occurs.

Was this article helpful?