Article Details
Id:14037
Product:finPOWER Connect
Type:FIX
Version:3.00.02
Opened:23/08/2016
Closed:23/08/2016
Released:07/10/2016
Job: J017935

Bank Batch; Commit may fail with an error if there are split lines

A Bank Batch Commit may fail with an error under the following conditions:

1. A Bank Transaction has multiple split lines.
2. One or more lines are valid.
3. One or more lines have a zero value and no Account defined.

For an Access database the error message is "Failed to commit Bank Batch. Failed to add new record in UpdateQueryBuilder. You cannot add or change a record because a related record is required in table 'Account'.". For a SQL Server database the message is "Failed to commit Bank Batch. Failed to add new record in UpdateQueryBuilder.
The INSERT statement conflicted with the FOREIGN KEY constraint "RI_AccountAccountTransa_1". The conflict occurred in database "[DatabaseName]", table "dbo.Account", column 'Pk'. The statement has been terminated.".

You can correct the issue by removing the blank line.