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

A succession of errors occurs when posting the Student Billing sub ledger to the General Ledger through the General Ledger. The errors are as follows:

Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_GL7TRANSACTIONS_GL7BATCHESID_GL7BATCHES". The conflict occurred in database "StMarys", table "dbo.GL7BATCHES", column 'GL7BATCHESID'.
Native error:547
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
Native error:3621

Run-time error '-2147219866 (80040666)':
The specified record could not be found. The record has either been deleted or you do not have rights to view it.

Run-time error '440':
Automation error

Run-time error '-2147418105 (80010007)':
Automation error
The callee (server [not server application]) is not available and disappeared; all connections are invalid. The call may have executed.

Article Number: 50495

Products: